me gustaria saber por que obtengo un error al intentar crear la siguiente tabla:
Código PHP:
DROP TABLE IF EXISTS `adds`;
CREATE TABLE `adds` (
`id` int(11) NOT NULL auto_increment,
`text` text collate latin1_general_ci NOT NULL,
`type` tinytext collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE
ERROR:
Código PHP:
MySQL ha dicho: Documentación
#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 latin1_general_ci NOT NULL,
`type` tinytext collate l