Hi,
I have included show from two tables both have the same problem in two
different databases.
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show create table 'navprompts'
-> ;
ERROR 1064 (42000): 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 ''navp
rompts'' at line 1
mysql> show create table 'peterkrolltiles.navprompts';
ERROR 1064 (42000): 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 ''pete
rkrolltiles.navprompts'' at line 1
mysql> SHOW CREATE TABLE navprompts\G
ERROR 1046 (3D000): No database selected
mysql> SHOW CREATE TABLE peterkrolltiles.navprompts \G
*************************** 1. row ***************************
Table: navprompts
Create Table: CREATE TABLE `navprompts` (
`languagecode3` varchar(3) NOT NULL default '',
`navigation` varchar(110) default NULL,
`home` varchar(110) default NULL,
`aboutus` varchar(110) default NULL,
`products` varchar(110) default NULL,
`team` varchar(110) default NULL,
`visualtour` varchar(110) default NULL,
`gallery` varchar(110) default NULL,
`applications` varchar(110) default NULL,
`contactus` varchar(110) default NULL,
PRIMARY KEY (`languagecode3`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.62 sec)
mysql> SHOW CREATE TABLE mainbyrob.distinfocontent \G
*************************** 1. row ***************************
Table: distinfocontent
Create Table: CREATE TABLE `distinfocontent` (
`languagecode3` varchar(3) NOT NULL default '',
`block1` text NOT NULL,
`block2` text NOT NULL,
PRIMARY KEY (`languagecode3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql>
Thanks
Rob
Gleb Paharenko wrote:
>Hello.
>
>Please, send us the output of the following statement:
> show create table 'your table';
>
>
