Find the answer to your Linux question:
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Engineer Freston's Avatar
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    1,049

    undeletable table in MySQL?


    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       |
    | day20101017);     |
    +-------------------+
    I've corrected the sed mishap and imported the database the way it was intended
    Code:
    mysql> show tables;
    +-------------------+
    | Tables_in_someday |
    +-------------------+
    | day20101016       |
    | day20101017);     |
    | day20101017       |
    +-------------------+
    But I can't seem to drop the table day20101017); because no matter how I seem to escape it it errors.
    Can't tell an OS by it's GUI

  2. #2
    Just Joined!
    Join Date
    Oct 2010
    Posts
    6

    Try changing the delimiter

    Did you try
    Code:
    DELIMITER //
    DROP TABLE `day20101017);`//
    DELIMITER ;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •