How to clear the MySQL screen opened through the MySQL Command Line Client on Windows XP
MysqlWindowsCommand LineCmdMysql Problem Overview
How do i clear the MySQL screen, which I opened through the MySQL Command Line Client?
The operating system is Windows XP.
Mysql Solutions
Solution 1 - Mysql
> 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.
Solution 2 - Mysql
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)
Solution 3 - Mysql
\! 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.
Watch this activity : https://www.youtube.com/watch?v=CcbmE56O87U
Solution 4 - Mysql
You could use system clear like @Singamalai mentioned or even use keyboard shortcut like CTRL + L
Solution 5 - Mysql
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.:)
Solution 6 - Mysql
You can clear the screen with:
system cls
Or alternatively
\! cls
Solution 7 - Mysql
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
- Exit mysql
- Type
clsat the powershell prompt - Drop back into the mysql shell again
It's a kind of workaround, but it works for me, I guess.
Solution 8 - Mysql
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.