CREATE TABLE `immagini` (
`num_immagine` int( 6 ) unsigned NOT NULL AUTO_INCREMENT ,
`immagine` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
`titolo` varchar( 255 ) COLLATE utf8_bin default NULL ,
`num_articolo` int( 6 ) NOT NULL default '0',
`num_artista` int( 4 ) NOT NULL default '0',
PRIMARY KEY ( `num_immagine` ) ,
FULLTEXT KEY `titolo` ( `titolo` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT =1
MySQL a répondu
ocumentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_bin NOT NULL default '',
`titolo` varchar(255)
Partager