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> \! clearYou can make use of 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,
More Posts related to MySQL,
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- Connection Failed: 1130 PHP MySQL Error
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to clear mysql console screen
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- How to find AUTO_INCREMENT Fields value in MySQL table
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
More Posts:
- Move from Zsh to Bash shell macOS - MacOS
- Share image and text Twitter using your Android Application Programatically - Twitter
- Find Covid-19 Vaccine centers on macOS or iOS Maps App - News
- Java TLSv1.3 protocol code example using SSLSocket - Java
- How to recover unsaved notepad file Windows 10 - NotepadPlusPlus
- How to check your IP using bash for Windows? - Bash
- WhatsApp launches WhatsApp Web to Access Messages over web browser - WhatsApp
- How to hide or remove quick launch left navigation from SharePoint Online Modern site page - SharePoint
