using of mysqldump V 8.22 and table names with special character #
"Rik van Druten" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
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 -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]