Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 2177543MySQL - Using If Then Else in MySQL UPDATE or SELECT Queries

    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.

  2. air-gap.com.au › creating-mysql-insert-and-update-statements-with-excelCreating MYSQL Insert and Update statements with EXCEL - Air-Gap

    1) Like the first example, layout your data into columns. 2) Double click into the next blank column beside you’re first row and insert the following formula. = “update table_name set column_value_to_update = ‘” & C2 & “‘ where column_primaryKey = ‘” & A2 & “‘;” 3) Change the 3 default formula values: table_name, column ...

  3. nsiteful.com › sql-subquery-excelMySQL: Update table using subquery, Excel data

    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). Perhaps you could adapt this solution to your own situation.

  4. dirask.com › posts › MySQL-UPDATE-query-with-IF-condition-conditional-update-pOv4JDMySQL - UPDATE query with IF condition (conditional update)

    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:

  5. www.teachexcel.com › excel-tutorial › 2663Connect to MySQL from Excel (Complete Guide) - TeachExcel.com

    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.

  6. superuser.com › questions › 294175How to have a whole, refreshable MySQL database inside Excel

    I know how to import a MySQL database into Excel. I know how to "open" a table via ODBC from Excel and this table is now refreshable. The second thing is close to what I want, but I would like all the tables to be in an Excel file (probably each table in a different tab). Is there a way to do this?

  7. www.geeksforgeeks.org › mysql-if-if-then-if-then-else-and-if-then-elseif-elseIF, IF-THEN, IF-THEN-ELSE and IF-THEN-ELSEIF-ELSE Statement -...

    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