EN
MySQL - what does "ENGINE=InnoDB" mean?
1
answers
0
points
Can you explain to me what does ENGINE=InnoDB; mean when creating a MySQL table?
Example:
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? ----
1 answer
0
points
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.
Note:
InnoDB is the default engine in more recent versions of MySQL.
0 comments
Add comment