Hello.
Does the problem remains with MySQL Query Browser and mysql command line client when you are using a 'source' command? Rob Cochrane <[EMAIL PROTECTED]> wrote: > 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'; >> >> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
