[CLUG-tech] A table called #
jerith at jerith.za.net
Tue Dec 4 16:21:18 SAST 2007
Ben Bartrum wrote:
> I have a MySQL 4.0.20 database, and I created a dump file of it. When I tried to import it on another server (different platform), I get this error:
> ERROR 1064 at line 11: 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 'varchar(255) default NULL,
> id varchar(255) default NULL,
> 'Show tables' on the original server shows there is a table called # (really just #)
> When I look at the sqldumpfile, line 11 shows:
> CREATE TABLE # (
> If I change this to
> CREATE TABLE `#` (
> (using backticks) it works. But how can I prevent this from happening every time?
Obvious answer: call the table something else?
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 3249 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.clug.org.za/pipermail/clug-tech/attachments/20071204/1a0ab735/attachment.bin
More information about the clug-tech