MySQL on duplicate update not updating
I'm attempting to run the following statement:
INSERT into table (col1,col2,col3,col4)
VALUES ('1','2','3','4')
ON DUPLICATE KEY UPDATE col3 = '3'
According to many of the examples in the forums, this should work on the
record currently in the system, but when I execute this and run a select
afterwards, col3 is unaffected. I get no errors when running the insert
statement. Any ideas?
No comments:
Post a Comment