Results 1 to 2 of 2
Help?
A sed mishap prior to a database import left me with a table name with, eh, well, this:
Code:
mysql> show tables;
+-------------------+
| Tables_in_someday |
+-------------------+
| day20101016 ...
- 10-17-2010 #1
undeletable table in MySQL?
Help?
A sed mishap prior to a database import left me with a table name with, eh, well, this:
I've corrected the sed mishap and imported the database the way it was intendedCode:mysql> show tables; +-------------------+ | Tables_in_someday | +-------------------+ | day20101016 | | day20101017); | +-------------------+
But I can't seem to drop the table day20101017); because no matter how I seem to escape it it errors.Code:mysql> show tables; +-------------------+ | Tables_in_someday | +-------------------+ | day20101016 | | day20101017); | | day20101017 | +-------------------+
Can't tell an OS by it's GUI
- 10-18-2010 #2Just Joined!
- Join Date
- Oct 2010
- Posts
- 5
Try changing the delimiter
Did you try
Code:DELIMITER // DROP TABLE `day20101017);`// DELIMITER ;


Reply With Quote