Custom ordering (order rows by my order).
Copy data from one tabe to another (update existed records).
Shows how to get the value from updated row in one query (without additional SELECT query).
When developing an internet site, you may often see developers making recurring mistakes when designing databases.
Today I decided to publish own FAQ answers for working with MySQL.
Creating a backup:
mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
Creating a database structure without data:
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql