LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (http://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   cant create table user-test (http://www.linuxquestions.org/questions/linux-newbie-8/cant-create-table-user-test-4175418227/)

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 07:30 AM.