| Login to MySQL |
mysql -u user -p |
Login to MySQL server. |
| Show databases |
SHOW DATABASES; |
List all databases. |
| Use database |
USE database_name; |
Select a database. |
| Show tables |
SHOW TABLES; |
List all tables in the database. |
| Describe table |
DESCRIBE table_name; |
Show table structure. |
| Create database |
CREATE DATABASE db_name; |
Create a new database. |
| Create table |
CREATE TABLE table_name (...); |
Create a new table. |
| Insert data |
INSERT INTO table_name (...) VALUES (...); |
Insert data into table. |
| Select data |
SELECT * FROM table_name; |
Query data from a table. |
| Update data |
UPDATE table_name SET col='val' WHERE condition; |
Update existing data. |
| Delete data |
DELETE FROM table_name WHERE condition; |
Delete rows from table. |
| Backup database |
mysqldump -u user -p db_name > backup.sql |
Export database to file. |
| Restore database |
mysql -u user -p db_name < backup.sql |
Import database from file. |