Renaming of table causes update to fail, refers to old table name.

[Able3 Ventures (Jayaram)]

This is probably something simple but I am unable to proceed.

I had a table named LMdata and I renamed it to WFData.

Now, when I try to update a value in the renamed table using MySQL Workbench, it is still looking for the old table name.

Executing:

UPDATE `lmlaser`.`WFData` SET `B1LaserQty` = '0' WHERE (`RowNum` = '1624');

Operation failed: There was an error while applying the SQL script to the database.
ERROR 1146: 1146: Table 'lmlaser.LMdata' doesn't exist

Can someone please tell me how I can fix this issue?

Thanks,

Jayaram

[Harmit Rishi (Cloud Platform Support)]

Hello Jayaram,

For the purposes of clarity, would you be able to confirm if you are using the same steps for connecting to your Cloud SQL instance via MySQL workbench as outlined here?

You may have to update the default schema parameter once you have changed your table name.

Let us know how it goes!