[CLUG-tech] A table called #

Jeremy Thurgood jerith at jerith.za.net
Tue Dec 4 16:21:18 SAST 2007


Ben Bartrum wrote:
> Hello
> 
> 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,
>   en
> 
> '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?

--J
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
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 mailing list