CREATE TABLE `clan` (
`codigo_c` int(10) NOT NULL auto_increment,
`nome_c` varchar(100) collate latin1_general_ci NOT NULL default '',
`senha` varchar(80) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`codigo_c`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 ;
da esse erro:
Mensagens do MySQL :
#1064 - You have an error in your SQL syntax near 'collate latin1_general_ci NOT NULL default '',
`senha` varchar(80) collate la' at line 3
qq eu faço?
vlw!