Jump to content


Photo

Can't drop a mysql table


  • Please log in to reply
2 replies to this topic

#1 yrrahxob

yrrahxob
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationKaty, Texas

Posted 08 November 2003 - 08:41 PM

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
Harry R. Box
[br]We must all hang together or we shall surely hang separately.
[br]
[br]A well regulated Militia, being necessary to the security of a free State, the right of the people to keep and bear Arms, shall not be infringed."

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 09 November 2003 - 08:12 AM

Whats the error message you get?
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 yrrahxob

yrrahxob
  • Members
  • Pip
  • Newbie
  • 9 posts
  • LocationKaty, Texas

Posted 09 November 2003 - 04:18 PM

Error

SQL-query :

DROP TABLE

MySQL said:


#1064 - You have an error in your SQL syntax near \'\' at line 1
Harry R. Box
[br]We must all hang together or we shall surely hang separately.
[br]
[br]A well regulated Militia, being necessary to the security of a free State, the right of the people to keep and bear Arms, shall not be infringed."




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users