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. 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 · The UPDATE statement in MySQL is essential for modifying existing data in a table. It's commonly used to correct errors, update values, and make other necessary changes. This article explores the structure and use cases of

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

    How to create SQL update and insert statements with Excel easy to use formulas.

  4. github.com › mysql › mysql-for-excelGitHub - mysql/mysql-for-excel: MySQL for Excel is an Excel...

    MySQL for Excel now provides a way to edit a MySQL table's data directly within Excel using a new worksheet as a canvas to update existing data, insert new rows and delete existing ones in a very friendly and intuitive way.

  5. www.w3schools.com › mysql › mysql_updateMySQL UPDATE Statement - W3Schools

    The MySQL UPDATE Statement. The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax. UPDATE table_name. SET column1 = value1, column2 = value2, ... WHERE condition; Note: Be careful when updating records in a table! Notice the . WHERE clause in the UPDATE statement.

  6. 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).

  7. downloads.mysql.com › docs › mysql-for-excel-enMySQL for Excel

    MySQL for Excel is an add-in that enables you to browse MySQL schemas, tables, views, and procedures from within Microsoft Excel. With MySQL for Excel, you can perform the following operations: • Import MySQL data into Excel. • Export Excel data to MySQL as a new table or append data to an existing table.