From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Converting the table engine

Converting the table engine

From the course: Learning phpMyAdmin

Start my 1-month free trial

Converting the table engine

“

- Before setting up foreign key constraints you need to check that the parent and child tables both use the InnoDB storage engine, and change them if necessary. Both operations are very simple. We're working with the up_and_running database so select that and then make sure that the Structure tab is selected. Now I've got this makes_ods table which was created for a demonstration earlier. We don't need that anymore so I'm going to Drop it, and then just click Ok. So now we've got the two tables that we want to join, cars, and makes. They're both InnoDB and the database itself is also InnoDB. It might come as a surprise but tables don't need to use the same storage engine as the database. Nor do they all need to be the same. In fact, it's recommended to choose the most appropriate storage engine for each table, rather than to stick to just one. MyISAM tables are particularly suited to storing large amounts of data that is unlikely to change, and until MySQL 5.6 you needed to use MyISAM…

Contents