La clause, AUTO_INCREMENT, permet \u00e0 MySQL de g\u00e9n\u00e9rer un entier unique pour tout nouvel enregistrement d’une table. Cette clause ne peut se mettre que sur les champs de type entier, index\u00e9 et non nul. Elle est donc souvent utilis\u00e9e comme cl\u00e9 primaire.<\/p>\n
Cependant, sont comportement n’est pas tout \u00e0 fait identique sur une table MyISAM et sur une table InnoDB.<\/p>\n
\n
\n
mysql><\/span> CREATE TABLE table_myisam (id INT AUTO_INCREMENT PRIMARY KEY) engine=MyISAM;<\/p>\n mysql><\/span> SHOW CREATE TABLE table_myisam;<\/p>\n \n CREATE TABLE `table_myisam` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=MyISAM <\/strong>DEFAULT CHARSET=latin1<\/em><\/p>\n \n \n mysql><\/span> INSERT INTO table_myisam (id) VALUES (NULL),(NULL),(NULL),(100);<\/p>\n Query OK, 4 rows affected (0.02 sec)<\/em><\/p>\n Records: 4 Duplicates: 0 Warnings: 0<\/em><\/p>\n \n mysql><\/span> SELECT id FROM table_myisam;<\/p>\n +—–+<\/em><\/p>\n | id |<\/em><\/p>\n +—–+<\/em><\/p>\n | 1 |<\/em><\/p>\n | 2 |<\/em><\/p>\n | 3 |<\/em><\/p>\n | 100 |<\/em><\/p>\n +—–+<\/em><\/p>\n \n mysql><\/span> SHOW CREATE TABLE table_myisam;<\/p>\n \n CREATE TABLE `table_myisam` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=MyISAM AUTO_INCREMENT=101<\/strong> DEFAULT CHARSET=latin1<\/em><\/p>\n \n \n mysql><\/span> DELETE FROM table_myisam WHERE id=100;<\/p>\n mysql><\/span> SELECT id FROM table_myisam;<\/p>\n +—-+<\/em><\/p>\n | id |<\/em><\/p>\n +—-+<\/em><\/p>\n | 1 |<\/em><\/p>\n | 2 |<\/em><\/p>\n | 3 |<\/em><\/p>\n +—-+<\/em><\/p>\n \n mysql><\/span> SHOW CREATE TABLE table_myisam;<\/p>\n \n CREATE TABLE `table_myisam` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=MyISAM AUTO_INCREMENT=101<\/strong> DEFAULT CHARSET=latin1<\/em><\/p>\n \n \n mysql><\/span> CREATE TABLE table_innodb (id INT AUTO_INCREMENT PRIMARY KEY) engine=InnoDB;<\/p>\n mysql><\/span> SHOW CREATE TABLE table_innodb;<\/p>\n CREATE TABLE `table_innodb` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=InnoDB <\/strong>DEFAULT CHARSET=latin1<\/em><\/p>\n \n \n mysql><\/span> INSERT INTO table_innodb (id) VALUES (NULL),(NULL),(NULL),(100);<\/p>\n Query OK, 4 rows affected (0.22 sec)<\/em><\/p>\n Records: 4 Duplicates: 0 Warnings: 0<\/em><\/p>\n \n mysql><\/span> SELECT id FROM table_innodb;<\/p>\n +—–+<\/em><\/p>\n | id |<\/em><\/p>\n +—–+<\/em><\/p>\n | 1 |<\/em><\/p>\n | 2 |<\/em><\/p>\n | 3 |<\/em><\/p>\n | 100 |<\/em><\/p>\n +—–+<\/em><\/p>\n \n mysql><\/span> SHOW CREATE TABLE table_innodb;<\/p>\n CREATE TABLE `table_innodb` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=InnoDB AUTO_INCREMENT=101<\/strong> DEFAULT CHARSET=latin1<\/em><\/p>\n \n \n mysql><\/span> DELETE FROM table_innodb WHERE id=100;<\/p>\n mysql><\/span> SELECT id FROM table_innodb;<\/p>\n +—-+<\/em><\/p>\n | id |<\/em><\/p>\n +—-+<\/em><\/p>\n | 1 |<\/em><\/p>\n | 2 |<\/em><\/p>\n | 3 |<\/em><\/p>\n +—-+<\/em><\/p>\n \n mysql><\/span> SHOW CREATE TABLE table_innodb;<\/p>\n CREATE TABLE `table_innodb` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=InnoDB AUTO_INCREMENT=101<\/strong> DEFAULT CHARSET=latin1<\/em><\/p>\n \n \n \/*************************************\/<\/span><\/p>\n \/**** reboot du serveur MySQL<\/strong> ****\/<\/span><\/p>\n \/*************************************\/<\/span><\/p>\n \n mysql><\/span> SHOW CREATE TABLE table_myisam;<\/p>\n CREATE TABLE `table_myisam` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ) ENGINE=MyISAM AUTO_INCREMENT=101<\/strong> DEFAULT CHARSET=latin1<\/em><\/p>\n \n mysql><\/span> INSERT INTO table_myisam (id) VALUES (NULL);<\/p>\n mysql><\/span> SELECT id FROM table_myisam;<\/p>\n +—–+<\/em><\/p>\n | id |<\/em><\/p>\n +—–+<\/em><\/p>\n | 1 |<\/em><\/p>\n | 2 |<\/em><\/p>\n | 3 |<\/em><\/p>\n | 101<\/span><\/strong> |<\/em><\/p>\n +—–+<\/em><\/p>\n \n \n mysql><\/span> SHOW CREATE TABLE table_innodb;<\/p>\n CREATE TABLE `table_innodb` (<\/em><\/p>\n `id` int(11) NOT NULL AUTO_INCREMENT,<\/em><\/p>\n PRIMARY KEY (`id`)<\/em><\/p>\n ENGINE=InnoDB AUTO_INCREMENT=4<\/strong> DEFAULT CHARSET=latin1<\/em><\/p>\n \n mysql><\/span> INSERT INTO table_innodb (id) VALUES (NULL);<\/p>\n mysql><\/span> SELECT id FROM table_innodb;<\/p>\n +—-+<\/em><\/p>\n | id |<\/em><\/p>\n +—-+<\/em><\/p>\n | 1 |<\/em><\/p>\n | 2 |<\/em><\/p>\n | 3 |<\/em><\/p>\n | 4<\/strong> <\/span>|<\/em><\/p>\n +—-+<\/em><\/p>\n \n \n","protected":false},"excerpt":{"rendered":" La clause, AUTO_INCREMENT, permet \u00e0 MySQL de g\u00e9n\u00e9rer un entier unique pour tout nouvel enregistrement d’une table. Cette clause ne peut se mettre que sur les champs de type entier, index\u00e9 et non nul. Elle est donc souvent utilis\u00e9e comme cl\u00e9 primaire.<\/p>\n Cependant, sont comportement n’est pas tout \u00e0 fait identique sur une table MyISAM et sur une table InnoDB.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8],"tags":[22,24,23,241],"class_list":["post-56","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-auto_increment","tag-innodb","tag-myisam","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\n<\/em><\/p>\n
\n<\/em><\/p>\n
\n<\/em><\/p>\n
\n<\/em><\/p>\n
\n<\/em><\/p>\n
\n<\/em><\/p>\n
\n<\/em><\/p>\n