Can't Create/Edit/Drop Specific Table
Posted by:
Near Miss
Date: June 23, 2008 10:36AM
I had a table named "lines". All of a sudden this morning, I could not access this table from the cli. Everything I tried, even a simple "DESC lines;" returned:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lines' at line 1
I was however able to access and edit the table via phpmyadmin. I dropped the table via phpmyadmin, and tried re-creating it via the CLI, but get the same error messages.
I also tried creating a brand new database, and creating a "lines" table in it, and I also get the same error. So I can't create table called "lines" in any db, new or old, at the moment.
Any ideas? I may have a view involving this table, if that may cause problems, however a SHOW VIEWS also returns the above error message.
Mysql Ver: 5.0.32-Debian_7etch4-log
Subject
Written By
Posted
Can't Create/Edit/Drop Specific Table
June 23, 2008 10:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.