Jump to content

Archived

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

yrrahxob

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

Error

 

SQL-query :

 

DROP TABLE

 

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.