Hola, me da este error cuando ejecuto la consulta
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 '; DROP TABLE IF EXISTS `categoria`;CREATE TABLE IF NOT EXISTS `categoria` ( `id' at line 1
sql = "DROP TABLE IF EXISTS `categoria`;"&_
"CREATE TABLE IF NOT EXISTS `categoria` ("&_
" `id` int(11) NOT NULL,"&_
" `idmenu` int(11) NOT NULL,"&_
" `nombre` text character set utf8 collate utf8_spanish_ci NOT NULL"&_
") ENGINE=InnoDB DEFAULT CHARSET=latin1;"
Cmd.CommandText=sql
Cmd.Execute
