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 · How do I update a table and set different values upon the condition evaluating to True. For instance : UPDATE Table SET A = '1' IF A > 0 AND A < 1 SET A = '2' IF A > 1 AND A < 2 WHERE A IS NOT NULL;

  2. 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.

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

  4. medium.com › @ikychant › how-to-edit-your-mysql-database-directly-in-microsoftHow to Edit MySQL Database directly in Microsoft Excel

    7 gru 2019 · MySQL for Excel requirements: NET Framework 4.0. Microsoft Excel 2007 or later. Visual Studio 2010 Tools for Office Runtime. An available MySQL Server connection. So… Let's Get Started! In...

  5. www.w3resource.com › mysql › exporting-and-importing-data-between-mysql-andExporting and importing data between MySQL and Microsoft excel

    19 sie 2022 · Data can be imported from MySQL into a Microsoft Excel spreadsheet by using the Import MySQL Data option after selecting either a table, view, or procedure to import. First of all, you do the first 6 steps describe above in "Edit MySQL Data in Excel" then select your table which you want to import.

  6. zebrabi.com › guide › how-to-integrate-mysql-into-excelHow to Integrate MySQL Into Excel - Zebra BI

    21 lip 2023 · 1. Setting up MySQL Database for Excel Integration. 2. Installing and Configuring MySQL Connector for Excel. 3. Linking MySQL Database Tables to Excel Worksheets. 4. Importing Data from MySQL into Excel. 5. Exporting Data from Excel to MySQL Database. 6. Automating Data Updates between MySQL and Excel. 7.

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

    UPDATE Table. The following SQL statement updates the first customer (CustomerID = 1) with a new contact person and a new city.