How to clear MySQL Console Screen

Working with MySQL on Terminal (Command Line or another console) is one of the ways many developers prefer to access the Database servers, at times one might want to flush the screen and then run the SQL statement, cls or clear commands won't work, let's see how to do it,

mysql> mysql> select *
    -> from my_table
    -> where name='abc';


mysql> \! clear

You can make use of the command "\! clear", backslash and exclamation is can be used in terminal to clear system shell commands.

There is another way, if you want to just clear one command executed at a time, you can make use of Command + L on macOS, Control + L on Linux devices like Ubuntu,

Have Questions? Post them here!