Search results
1 lut 2010 · Here's a query to update a table based on a comparison of another table. If record is not found in tableB, it will update the "active" value to "n". If it's found, will set the value to NULL. UPDATE tableA LEFT JOIN tableB ON tableA.id = tableB.id SET active = IF(tableB.id IS NULL, 'n', NULL)"; Hope this helps someone else.
29 gru 2017 · I am trying to understand how to UPDATE multiple rows with different values and I just don't get it. The solution is everywhere but to me it looks difficult to understand. For instance, two updates into 1 query: UPDATE mytable SET fruit='orange', drink='water', food='pizza' WHERE id=1;
In this article, we would like to show you UPDATE query with IF condition in MySQL. Quick solution: UPDATE `table_name` SET `column_name` = IF(condition , if_true, if_false); Practical example. To show UPDATE query with IF condition, we will use the following users table:
16 lut 2024 · In this article, we’ll learn the use of the CASE statement, IF() function, INSERT ... ON DUPLICATE KEY UPDATE clause and UPDATE with JOIN() function to update multiple columns in multiple rows with different values in MySQL.
15 mar 2012 · It's a single line update query to update multiple rows in a table based on conditions. UPDATE table SET salary = Case WHEN designation='developer' THEN salary + salary*0.20 WHEN designation='manager' THEN salary + salary*0.30 END
UPDATE Multiple Records. It is the WHERE clause that determines how many records will be updated. The following SQL statement will update the PostalCode to 00000 for all records where country is "Mexico": Example. UPDATE Customers. SET PostalCode = 00000. WHERE Country = 'Mexico'; The selection from the "Customers" table will now look like this:
11 lip 2024 · The IF function in MySQL allows for conditional logic to return specific results based on the evaluation of a condition. This specific query involves two parts: A subquery that contains a CASE expression: SELECT CASE WHEN 1 > 0 THEN 'true' ELSE 'false' END: The CASE expression checks the condition 1 > 0.
