1146 MySqlCC error cant update table data.

[SundancerKid]

Hi everyone,

I am working with MYSQLCC (Control Center) and when I try and add data to a table using the run query it errors out with error 1146.

error 1146. table rossoptical.1 doesn't exist.

my table name is asphericallenses

It seems like there is a reference pointer problem!

This is my first time using the MYSQLCC and I dropped the table and recreated it with all of the data. I Still the same problem.

I have read a lot about other problems here and I think I have done everything suggested.

even when I run the select query I get the same problem, but I do see the columns of data, I just can not change the data.

Please Help!!

Thanks

Rick

 

[TonyGroves]

Can you do a SHOW CREATE TABLE ASPHERICALLENSES and post the results here, along with the query you are trying to run?