Search results
1 cze 2015 · If you specify ON DUPLICATE KEY UPDATE, and a row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row is performed. Please read URL for more details.
29 kwi 2015 · IF EXISTS (select * from users where username = 'something') THEN. update users set id= 'some' where username = 'something'; ELSE. insert into users (username) values ('something'); END IF; end $$. delimiter ; and call it like this: call select_or_insert();
2 lut 2024 · Use REPLACE INTO to Update the Record if It Exists Else Insert It in the MySQL Table. One approach is to use the REPLACE statement if you want to truly replace rows when the INSERT commands would fail due to duplicate UNIQUE or PRIMARY KEY values as described previously.
17 paź 2024 · MySQL provides two ways to insert a row into a table or update the row if it already exists. We can use the INSERT INTO … ON DUPLICATE KEY UPDATE syntax or the REPLACE statement.
27 sty 2024 · Here’s how you would insert a new product or update the quantity if it already exists. INSERT INTO products (id, name, quantity) VALUES (1, 'Widget', 10) ON DUPLICATE KEY UPDATE quantity = VALUES(quantity) + 10;
You can use the INSERT INTO …. ON DUPLICATE KEY UPDATE statement in MySQL to achieve this. This statement will insert a new row into the table, or if a duplicate key violation occurs (i.e., a row with the same primary or unique key exists), it will update the existing row with the new values. Here’s the SQL query:
23 gru 2009 · One options is using on duplicate update syntax. http://dev.mysql.com/doc/refman/5.1/en/insert-on-duplicate.html. Other options is doing select to figure out if record exists and then doind inser/update accordingly. Mind that if you're withing transaction select will not explicitly terminate the transaction so it's safe using it.
