| Action | Command | Details |
|---|---|---|
| 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. |