Hello.
Does the problem remains with MySQL Query Browser and mysql command line client
when you are using a 'source' command?
Rob Cochrane <rob@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
