-   Linux - Newbie (
-   -   cant create table user-test (

figure20012 07-23-2012 07:47 AM

cant create table user-test
i have to create a table in mysql named user-test

ERROR 1064 (42000): 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 ''devin-test'(name varchar(20))' at line 1

please help

figure20012 07-23-2012 07:56 AM

i got the trick

create table '`user-test`'

using back ticks

All times are GMT -5. The time now is 11:03 PM.