Re: [Asset-tracker-users] dashes "-" in mysql

[Kurt Y. <ky...@sh...>]

Yes, if I had it to do over again I'd probably choose an underscore 
instead. But changing this now would probably cause a lot of pain for 
people. So for the meantime, you can put the table name in `` to get 
around this. Like so:

mysql> desc `sample-assets`;

On Jan 25, 2004, at 12:07 AM, John T. Stucki wrote:

> You might want to choose another delimter in your table naming 
> conventions.  mysql does not like dashes "-" in the table names:
>
> ex.
>
> mysql> desc sample-assets;
> ERROR 1064: 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 '-assets' at line 1
> mysql>
> mysql> desc "sample-assets";
> ERROR 1064: 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 '"sample-assets"' at line 1
> mysql> desc "sample\-assets";
> ERROR 1064: 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 '"sample\-assets"' at line 1
> mysql>
>
> my MySQL server version is Ver 12.22 Distrib 4.0.17, for pc-linux 
> (i686)
>
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Asset-tracker-users mailing list
> Ass...@li...
> https://lists.sourceforge.net/lists/listinfo/asset-tracker-users