SQL UPDATE not working
Posted: Thu Jan 04, 2018 12:06 am
I am having problems with the following SQL statement:
UPDATE vendor SET period_name_fq1 = '2017H2';
The statement executes, returning 0 rows updated. I confirmed that no rows have been changed. Note that none of the rows have this value currently. My expected outcome is for all rows in this table to be updated. I tried adding a WHERE clause but it did not make a difference - still 0 rows updated. I am using MySQL 5.7. "period_name_fq1" is a VARCHAR(7) column in the table "vendor".
I must be missing something basic, but I cannot see what. Has anyone run into this problem?
UPDATE vendor SET period_name_fq1 = '2017H2';
The statement executes, returning 0 rows updated. I confirmed that no rows have been changed. Note that none of the rows have this value currently. My expected outcome is for all rows in this table to be updated. I tried adding a WHERE clause but it did not make a difference - still 0 rows updated. I am using MySQL 5.7. "period_name_fq1" is a VARCHAR(7) column in the table "vendor".
I must be missing something basic, but I cannot see what. Has anyone run into this problem?