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> \! clearYou 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!
More Posts related to MySQL,
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL Query for Schema/Structure of a Table
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- Connection Failed: 1130 PHP MySQL Error
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- How to find AUTO_INCREMENT Fields value in MySQL table
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- How to clear MySQL Console Screen
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- Fix MySQL ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- Display List of Databases in mysql Command Line
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL: How to Select Database via Terminal/Command Line
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Identify MySQL version in MySQL Command Line Prompt
More Posts:
- [Solved] SharePoint Search Internal server error exception - SharePoint
- What is the doctype for HTML5? - Html
- Setting $JAVA_HOME Environment Variable in macOS - MacOS
- -bash: startup.sh: command not found - Apache Tomcat 8 - Tomcat
- PowerShell - How to use Try Catch Finally blocks for error exception handling (Windows/SharePoint) - SharePoint
- How to reset eclipse layout - Android
- Hide cURL Outputs and Errors on Terminal - cURL
- Convert String to int in Java - Java
