An ALTER TABLE shortcut If you’re simply upgrading your tables from ISAM to MyISAM, you can use the command mysql_convert_table_format instead of writing ALTER TABLE statements. You can use the ...

The command-line client is nice too. Also, I use MariaDB instead of MySQL in my examples ... so nothing will happen. The ALTER Statement Suppose I decide to remove the seriesid column from the books ...