How to clear the MySQL CLI on Windows?

[santhanalakshmi]

Hi,

Is there any way to clear the screen in MySQL's command line prompt? (in windows)

[dgreenhouse]

Don't think there's an easy way to do it, but you could do this:
select repeat("\n",100 );

But... You'll see something like this at the bottom of the screen:
|
+-----------------------------------------------------------+
1 row in set (0.00 sec)

[santhanalakshmi]

hi sir,
thanks.....Is there is any other query to clear MYSQL Command-Line prompt......... .......

[Atli]

No. The MySQL CLI uses the CLI supplied by the OS, in your case the Windows CLI (cmd.exe). It doesn't seem to supply any means of clearing the screen. The MySQL CLI is, therefore, subject to those same restrictions.

You would have to get a 3'rd party CLI, or just move on to a Unix system, to be able to do this.