yrrahxob Posted November 8, 2003 Share Posted November 8, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1324-cant-drop-a-mysql-table/ Share on other sites More sharing options...
shivabharat Posted November 9, 2003 Share Posted November 9, 2003 Whats the error message you get? Quote Link to comment https://forums.phpfreaks.com/topic/1324-cant-drop-a-mysql-table/#findComment-4401 Share on other sites More sharing options...
yrrahxob Posted November 9, 2003 Author Share Posted November 9, 2003 Error SQL-query : DROP TABLE MySQL said: #1064 - You have an error in your SQL syntax near \'\' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/1324-cant-drop-a-mysql-table/#findComment-4409 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.