Can you explain to me what does
ENGINE=InnoDB; mean when creating a MySQL table?
CREATE TABLE `users` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(100) NOT NULL, `country` VARCHAR(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=INNODB; -- <------ what does it mean? ----
MySQL has multiple storage engines that are used to create tables. They decide how and where the table data is stored. So basically
ENGINE=INNODB; means you are using InnoDB engine to create the table.
InnoDB is the default engine in more recent versions of MySQL.