1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Erreur
requête SQL:
CREATE TABLE `shop_livres` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`isbn` varchar( 10 ) NOT NULL default '',
`rubannu1` int( 11 ) unsigned NOT NULL default '0',
`rubannu2` int( 11 ) unsigned NOT NULL default '0',
`titre` text NOT NULL ,
`prix_ht` float NOT NULL default '0',
`prix_ttc` float NOT NULL default '0',
`parution` date NOT NULL default '0000-00-00',
`resume` text NOT NULL ,
`auteur` int( 11 ) unsigned NOT NULL default '0',
KEY `rubannu1` ( `rubannu1` , `rubannu2` , `auteur` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL a répondu:Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key |