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

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

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

    7 gru 2019 · Download the standalone installer: MySQL for Excel. Install it 😃. After the installation complete, launch Microsoft Excel, and then on the Data tab, click MySQL for Excel. Configuration...

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

  6. sqlspreads.com › blog › how-to-update-an-sql-table-from-excelHow to Update a SQL Table from Excel - SQL Spreads

    6 sie 2024 · How to Update an SQL Table from Excel. To set up an Excel document to work with the data in an SQL Server table, follow these few simple steps: Step 1: Download and install the Add-In. Download and install the SQL Spreads Excel Add-In. Step 2: Connect to your SQL Server Database.

  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.