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.
26 lut 2014 · Here’s a snippet of SQL code and a procedure for updating a MySQL database table using a subquery and data from Microsoft Excel (or similar).
21 sie 2024 · Data update and data insert are two important functions to add and update data in SQL Server Tables. Using SQL queries we can check for specific data if it exists in a table. The update query with the WHERE Clause can be used to update data passed from the front end or any other data generated from data processing during runtime.
16 kwi 2016 · For this example, you would have to use the standard logical operators: UPDATE Tests SET TestScore = CASE WHEN (TestId = 10 AND TestSubId = 25) THEN 1000 WHEN (TestId = 11 AND TestSubId = 22) THEN 1100 END, TestScore2 = CASE WHEN (TestId = 10 AND TestSubId = 25) THEN 2000 WHEN (TestId = 11 AND TestSubId = 22) THEN 2100 END WHERE (TestId = 10 ...
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:
24 mar 2017 · Update a MYSQL Table with an EXCEL. I have a mysql database with tables in it. I am currently able to export the data from this table into an Excel file using phpmyadmin. I modify it in Ms Excel and save it.
How to connect to a MySQL database from Excel, fetch the latest data from it, and work with that data inside your spreadsheets in Excel. This tutorial is step-by-step and shows you how to do everything, from downloading the ODBC drivers (explained in the tutorial) to importing and transforming the data from specific tables in MySQL.
