Mysql 1050 Error “Table already exists” when in fact, it does not

by

Sounds like you have Schroedinger’s table…

Seriously now, you probably have a broken table. Try:

  • DROP TABLE IF EXISTS contenttype
  • REPAIR TABLE contenttype
  • If you have sufficient permissions, delete the data files (in /mysql/data/db_name)

More Related Contents:

  1. If two columns are 1 then make new column
  2. MySQL – Get row number on select
  3. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  4. How can I tell when a MySQL table was last updated?
  5. Retrieving the last record in each group – MySQL
  6. Cast from VARCHAR to INT – MySQL
  7. Operand Should Contain 1 Column – MySQL NOT IN
  8. MySQL DELETE FROM with subquery as condition
  9. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  10. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  11. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  12. SQL Query to get column values that correspond with MAX value of another column?
  13. MySQL : transaction within a stored procedure
  14. When to use SELECT … FOR UPDATE?
  15. Setting column values as column names in the SQL query result
  16. Select from one table where not in another
  17. How to select the most recent set of dated records from a mysql table
  18. How to get current date & time in MySQL?
  19. Set value to NULL in MySQL
  20. Laravel join with 3 Tables
  21. SELECT query return 1 row from each group
  22. MySql Single Table, Select last 7 days and include empty rows
  23. mysql SQL: specific item to be first and then to sort the rest of the items
  24. How to regex in a MySQL query
  25. When is a timestamp (auto) updated?
  26. MySQL Group By Hours
  27. RMySQL dbWriteTable with field.types
  28. Syntax error on MERGE statement
  29. MySQL OPTIMIZE all tables?
  30. Deleting a row based on the max value

Leave a Comment