6 messages in com.mysql.lists.mysql-espregunta de principiante| From | Sent On | Attachments |
|---|---|---|
| Meteora Software | 25 Jun 2008 14:29 | |
| Alvaro Cobo | 25 Jun 2008 14:38 | |
| Alvaro Cobo | 25 Jun 2008 14:42 | |
| Diego Villar | 25 Jun 2008 16:03 | |
| Meteora Software | 26 Jun 2008 07:26 | |
| Diego Villar | 26 Jun 2008 09:34 |
| Subject: | pregunta de principiante |
|---|---|
| From: | Meteora Software (mete...@yahoo.com) |
| Date: | 06/25/2008 02:29:50 PM |
| List: | com.mysql.lists.mysql-es |
Estoy ejecutando el siguiente script en mysql 4.0.14, cual será el error de
sintaxis?
Error while executing this query:CREATE TABLE `pbcatcol` (
`pbc_tnam` varchar(30) DEFAULT NULL,
`pbc_tid` int(11) DEFAULT NULL,
`pbc_ownr` varchar(30) DEFAULT NULL,
`pbc_cnam` varchar(30) DEFAULT NULL,
`pbc_cid` smallint(6) DEFAULT NULL,
`pbc_labl` varchar(254) DEFAULT NULL,
`pbc_lpos` smallint(6) DEFAULT NULL,
`pbc_hdr` varchar(254) DEFAULT NULL,
`pbc_hpos` smallint(6) DEFAULT NULL,
`pbc_jtfy` smallint(6) DEFAULT NULL,
`pbc_mask` varchar(31) DEFAULT NULL,
`pbc_case` smallint(6) DEFAULT NULL,
`pbc_hght` smallint(6) DEFAULT NULL,
`pbc_wdth` smallint(6) DEFAULT NULL,
`pbc_ptrn` varchar(31) DEFAULT NULL,
`pbc_bmap` char(1) DEFAULT NULL,
`pbc_init` varchar(254) DEFAULT NULL,
`pbc_cmnt` varchar(254) DEFAULT NULL,
`pbc_edit` varchar(31) DEFAULT NULL,
`pbc_tag` varchar(254) DEFAULT NULL,
UNIQUE KEY `pbcatcol_idx` (`pbc_tnam`,`pbc_ownr`,`pbc_cnam`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
The server has returned this error message: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 'ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 23
MySQL Error.
Muchas gracias