mysql

Use mysql to interact with MySQL databases.

Common Commands

Connection

• Connect: mysql -h <host> -u <user> -p<password> <database>
• Execute query: mysql -e "SELECT * FROM table LIMIT 10" <database>

Inspection

• List databases: SHOW DATABASES;
• List tables: SHOW TABLES;
• Describe table: DESCRIBE <table_name>;

Operations

• Execute from file: mysql <database> < migration.sql
• Export: mysqldump -u <user> -p <database> > backup.sql
• Import: mysql <database> < backup.sql