![]() ![]() SHOW TABLES Code language: SQL (Structured Query Language) ( sql )Ĭreate a new table CREATE TABLE table_name( Show all available databases in the current MySQL database server SHOW DATABASE Code language: SQL (Structured Query Language) ( sql ) Working with tables DROP DATABASE database_name Code language: SQL (Structured Query Language) ( sql ) All physical files associated with the database will be deleted. Use a database or change the current database to another database that you are working with: USE database_name Code language: SQL (Structured Query Language) ( sql )ĭrop a database with a specified name permanently. Working with databasesĬreate a database with a specified name if it does not exist in the database server CREATE DATABASE database_name Code language: SQL (Structured Query Language) ( sql ) 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 |