To clear the screen content in MySQL use the command
mysql> \! clear
Usage of “\!” tells MySQL to pass the command to Linux OS to handle the request.
If you are in a Windows environment (DOS prompt), to pass the control to the OS you can use the command
mysql>system cls
Tags: clean window, clear screen, linux command to clear screen, MySql
FWIW, if you’re using MySQL server 5.1 in Windows, the “mysql>system cls” command from the command line does not appear to pass the command to the OS, and does not clear the screen. Thanks for the information here, though. Still, the only way I know of to clear the screen from the command prompt in windows is to quit MySQL, use a regular “cls” from the prompt, then log back into MySQL (mysql -u root -p). This, of course is not really effective.
For the Windows guys, I still haven’t run across anyone who knows how to accomplish this from within MySQL at the command prompt, if it’s possible to do. Simple to do in linux, but Windows…