To clear MySQL screen console window on Linux, you use the following command: mysql> system clear Ĭode language: SQL (Structured Query Language) ( sql )Ĭurrently, there is no command available on Windows OS for clearing MySQL screen console window. MySQL command-line client CommandsĬonnect to MySQL server using mysql command-line client with a username and password (MySQL will prompt for a password): mysql -u -p Code language: SQL (Structured Query Language) ( sql )Ĭonnect to MySQL Server with a specified database using a username and password: mysql -u -p Code language: SQL (Structured Query Language) ( sql )Įxit mysql command-line client: exit Code language: SQL (Structured Query Language) ( sql )Įxport data using mysqldump tool mysqldump -u -p > data_backup.sql Code language: SQL (Structured Query Language) ( sql ) MySQL cheat sheet provides you with one-page that contains the most commonly used MySQL commands and statements that help you work with MySQL more effectively.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |