How to clear the MySQL screen opened through the M

问题:

How do i clear the MySQL screen, which I opened through the MySQL Command Line Client?

The operating system is Windows XP.

回答1:

There is a number of solutions in Linux like this one, but the consensus seems to be there is none for Windows. See e.g. here or here (scroll to the bottom)

回答2:

Note: Please see @Pekka's answer for the Windows version, which seems to be that there is none for windows. However, this is a useful post to take a look at for windows. The remainder of this answer shows how you can do it in Unix / Linux and exists for historical significance as it has clearly been useful to some users.

To clear the editor screen in Unix/Linux you can type:

system clear

This makes use of mysql's system command to call the shell's clear command.

Note: the system command works only in Unix.

回答3:

You could use system clear like @Singamalai mentioned or even use keyboard shortcut like CTRL + L

回答4:

\! clear

Since 'clear' is a Linux operating system command and Linux and Mac OS X are both forms of Unix, this command might very well work fine for you too.

Please note that the '! ' in front of the clear command is used to tell MySQL to pass the command back to the OS to handle.

回答5:

I know this question is for Windows but since so many answers have been provided already I just thought to extend it for Linux users also so it will be beneficial for future users too.

So in Linux you can do

Ctrl + L

to clear the MySQL command window running through terminal.:)

回答6:

You can clear the screen with:

system cls

Or alternatively

\! cls

回答7:

Whenever I need to work on my stuff, I use Windows PowerShell to drop into the mysql shell. The only way I've found to clear the screen is to

1. Exit mysql
2. Type cls at the powershell prompt
3. Drop back into the mysql shell again

It's a kind of workaround, but it works for me, I guess.

回答8:

I done this workaround for Windows Right-click on the top frame of console -> Properties -> Layout -> and set Screen Buffer Size Height to large number.