Jump to content


This topic is now archived and is closed to further replies.


Can't drop a mysql table

Recommended Posts

I was writing a script that creates a temporary table based on a users login name. The first time I ran the script, the login name was not passed correctly to the next script and the query created a table with a NULL name. Now I get an error message when I use phpmyadmin to try to drop the table. Is there anyway of getting rid of this table short of exporting the data in every other table one at a time then dropping the entire database then recreating it and importing all the tables back to it.


Someone pleeeeeeeze help. This is a very large database.


Thank you.


BTW. I am using phpmyadmin version 2.5.4

Share this post

Link to post
Share on other sites



SQL-query :




MySQL said:



#1064 - You have an error in your SQL syntax near \'\' at line 1

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.