How to Dump MySQL Tables Without Data
Use the mysqldump command with the –no-data option:
MySQL Database
How to Output a MySQL Query to CSV
To output a MySQL query to a CSV file, the query needs to be altered.
How to Recover the MySQL root Password
Introduction If the root password for MySQL has been forgotten, there is a way to reset it. The process involves stopping the MySQL server and starting it in safe mode.
How to Rename a MySQL Table
To rename a MySQL table use RENAME TABLE with the old name then the new name after the TO keyword.
How to Delete a Field in a MySQL Table
To delete a column in a MySQL database column, use the DROP COLUMN keywords with ALTER TABLE. Do not mistake deleting a field for deleting a record.
How to Rename a Field in a MySQL Table
To change the name of a field in a MySQL database table use the CHANGE keyword with ALTER TABLE. You must also supply the field type again or you can change that too in the same line. Example: ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);