How to clear mysql console screen


Working with mysql on Terminal (Command Line) is one of the ways many developers use on the severs, at times one might want to flush the screen and then run the sql statement, cls or clear commands won't work, lets see how to do it,

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


mysql> \! clear

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

Clear mySQL Console Screen

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,

Advertisements
Try Out Code2care Dev Tools:

Advertisements



#Android #Java #Linux #Microsoft #Google #Python #MacOS #Notepad++ #Microsoft Teams #CSS #PHP #SharePoint #Html #Linux #C-Program #Bootstrap #jQuery #Sublime #Android-Studio #Facebook #Eclipse #WhatsApp #News #MySQL #Json #HowTos #JavaScript #FTP #S3


Advertisements


Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Tutorials, Trouble-Shooting steps, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.
🎉 We are celebrating the 10th years of Code2care! Thank you for all your support! We hope we made a difference.
We strong support Gender Equality & Diversity.

We stand in solidarity with Ukraine - Make a donation to UNHCR - https://donate.unhcr.org/in/en-in/ukraine-emergency