fworks-tech 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
Notes
- Avoid passing password as command-line argument in shared environments
- Use
~/.my.cnffor stored credentials