mysql

sk8guitar · 08-04-2003, 12:11 PM

i know its not a programming language, but i basically ask all my computer questions in this board anyways.

i managed to create a table in mysql that has a name "2". i want to get rid of that sucker, but going "drop table 2" doesn't work.

is there any way to do this?

MartBrooks · 08-04-2003, 12:17 PM

Did you type "drop table 2" or "drop table 2;" ?

sk8guitar · 08-04-2003, 01:44 PM

i mean i put in the semi colon. it gave me an error.

sk8guitar · 08-04-2003, 01:44 PM

Code:

mysql> drop table 2;
ERROR 1064: You have an error in your SQL syntax near '2' at line 1
mysql> drop table "2";
ERROR 1064: You have an error in your SQL syntax near '"2"' at line 1
mysql> drop table '2';
ERROR 1064: You have an error in your SQL syntax near ''2'' at line 1
mysql>

kev82 · 08-04-2003, 03:35 PM

i think its got something to do with the fact 2 is a number and not a string but if thats the case im confused as to how you created the table in the first place. also i dont know if mysql accepts lower case commands because sql commands should technically be in upper case. can you post how you created the table?

david_ross · 08-04-2003, 03:56 PM

You need to use backticks:
drop table `2`;

sk8guitar · 08-05-2003, 07:55 AM

rock on, it worked.

well the way i made it was through a php script. what it did was take the "playlist ID" from the master playlist table and use that ID to make a new table with that name that would hold hte playlist for that dj.

the backticks worked great. thanks david. much appreciated