Re: using of mysqldump V 8.22 and table names with special character #

Rik van Druten writes:
> I've noticed a problem and cannot resolve it:
> 
> It's possible to create a table with a column name like '#s'. Making of the 
> mysqldump wil work als expected. But when I'll try to put the generetad SQL 
> back into mysql. I'll get a syntax error 1064 at line.
> 
> I'll think the parser has a problem with the # character. I couldn't find 
> the right solution for this problem.
> 
> example:
> 
> CREATE TABLE uits2 (
> klant_id int(11) NOT NULL default '0',
> naam char(81) NOT NULL default '',
> #'i` bigint(21) NOT NULL default '0',
> geen_einde double(17,0) default NULL ) TYPE=MyISAM;
> 
> _________________________________________________________________
> MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl
> 
> 

Not a bug.

mysqldump can quote names if the option is used. 

Also, '#' is not allowed in column and table names.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]