Languages

MySQL - what does "ENGINE=InnoDB" mean?

0 points
Asked by:
Brett4
285

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
Answered by:
Brett4
285

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
Native Advertising
ūüöÄ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

‚̧ԳŹūüíĽ ūüôā

Join