LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 07-23-2012, 07:47 AM   #1
figure20012
Member
 
Registered: Apr 2012
Posts: 75

Rep: Reputation: Disabled
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
 
Old 07-23-2012, 07:56 AM   #2
figure20012
Member
 
Registered: Apr 2012
Posts: 75

Original Poster
Rep: Reputation: Disabled
i got the trick

create table '`user-test`'

using back ticks
 
  


Reply

Tags
mysql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
create partition table vbx_wx Linux - Newbie 9 07-28-2010 10:56 AM
How to create table in Joomla and store user at chat latino Programming 3 02-18-2010 03:23 AM
how to create a table using gtk? gktandc Programming 4 04-23-2009 06:28 AM
how to create ip rule table? yenonn Linux - Networking 6 07-25-2005 11:57 PM
MySQL / phpMyAdmin - Can only see test table after granting proper privelages.. Transition Linux - Software 2 02-03-2004 12:45 PM


All times are GMT -5. The time now is 01:44 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration