Collections:
VALUES() - Column Value for "ON DUPLICATE KEY UPDATE"
How to obtain the inserting value of given column in the "ON DUPLICATE KEY UPDATE" clause using the VALUES() function?
✍: FYIcenter.com
VALUES(col) is a MySQL built-in function that returns the inserting value of a given column and use it in the "ON DUPLICATE KEY UPDATE" clause. For example:
CREATE TABLE MyTable (id INTEGER UNIQUE, count INTEGER); INSERT INTO MyTable VALUES (1, 1) ON DUPLICATE KEY UPDATE count = count+VALUES(count); INSERT INTO MyTable VALUES (1, 1) ON DUPLICATE KEY UPDATE count = count+VALUES(count); INSERT INTO MyTable VALUES (1, 1) ON DUPLICATE KEY UPDATE count = count+VALUES(count); INSERT INTO MyTable VALUES (1, 1) ON DUPLICATE KEY UPDATE count = count+VALUES(count); SELECT * FROM MyTable; -- +------+-------+ -- | id | count | -- +------+-------+ -- | 1 | 4 | -- +------+-------+
Reference information of the VALUES() function:
VALUES(col): val Returns the inserting value of the given column. Arguments, return value and availability: col: Required. The column name referred in the INSERT statement. val: Return value. The inserting value of the given column. Available since MySQL 4.0.
⇐ UPDATEXML() - Updating Child Element in XML
2023-12-17, 214🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...