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';
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]