Monthly Archives: May 2016

Access and manipulate your database within Microsoft Excel (MySQL for Excel 1.3.6 has been released)

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

* Importing MySQL Data into Excel

* Exporting Excel data directly into MySQL to a new or existing table

* Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for Windows.

The MySQL Installer comes in 2 versions

- Full (150 MB) which includes a complete set of MySQL products with

their binaries included in the download.

- Web (1.5 MB – a network install) which will just pull the MySQL for

Excel over the web and install it when run.

You can download MySQL Installer from our official Downloads page at https://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_installer_&d=CwIFaQ&c=IV_clAzoPDE253xZdHuilRgztyh_RiV3wUrLrDQYWSI&r=b3rm4E2nx7aGlNTnMaOjlzWmTXv_sJTyehHR_J-0TT4&m=MNKqrM4wOBaJFL1sLBDcd_51hRakxL9J36IXe6W5Xao&s=biWElijgNfFAEB5zTpXOEzKFv8VnHeOK4NTfmjeP7HY&e=

The MySQL for Excel product can also be downloaded by using the product standalone installer found at this linkhttps://urldefense.proofpoint.com/v2/url?u=http-3A__dev.mysql.com_downloads_windows_excel_&d=CwIFaQ&c=IV_clAzoPDE253xZdHuilRgztyh_RiV3wUrLrDQYWSI&r=b3rm4E2nx7aGlNTnMaOjlzWmTXv_sJTyehHR_J-0TT4&m=MNKqrM4wOBaJFL1sLBDcd_51hRakxL9J36IXe6W5Xao&s=QTrLZCERkFq1f5vnvv3zVm6OZv8_YD2DWfcRpfUcmEM&e=

Changes in MySQL for Excel 1.3.6 (2016-01-07)

* Functionality Added or Changed

* Bugs Fixed

Functionality Added or Changed

* A new Generate an INSERT statement for each data row

option was added to the Advanced Options dialog for

Append and Export Data operations. This is disabled by

default. A single INSERT statement is generated that

inserts all affected rows, unless this option is enabled.

When checked, an INSERT statement for each data row being

appended or exported is generated in the resulting SQL

query sent to the MySQL server. When unchecked, a single

INSERT statement is generated as a bulk data operation,

which performs better than multiple INSERT statements.

While row-by-row inserts are slower, for debugging errors

it could help determine which row causes an error, since

the MySQL Server will process them row by row.

* Added column properties to the Export Data dialog to

support the definition of Auto Increment and Default

Value for new MySQL tables where the data will be

exported.

Added a context menu to declare a numeric field to be

Unsigned or to have Zero-Fill, accessible by

right-clicking the Data Type combo box.

Added the TIMESTAMP data type to the full list of valid

data types, as it was not being shown before. Added help

tool tips to fields in the Export Data dialog that

explain in detail how the column properties work in a

MySQL database.

Bugs Fixed

* The Pivot Table feature was updated to work with Excel

2016. (Bug #22387425)

* Closing the plugin via the Close button in the panel

would not toggle the MySQL for Excel checkbox in the Data

ribbon. (Bug #22374026, Bug #79655)

* Fixed the content detector for the active Excel cell

after importing data and after loading database objects

when a database is opened. Now, the data options are not

enabled until a table is selected. (Bug #22372915)

* Append and Export operations would not append/export

boolean data. (Bug #22138966)

* The MySQL for Excel Refresh All function would throw an

unhandled exception. (Bug #22110627, Bug #78941)

* With Office 2007, data would not auto-save after closing

Excel. (Bug #22081313, Bug #78910)

* Numeric data stored in text columns is now correctly

formatted by Excel as text, and not as the “General”

format that automatically formats cells as numbers when

the data is stored in a text object. This fixes the issue

where text columns were formatted as numbers, which

stripped leading zeros. (Bug #20905284, Bug #76738)

* Changed settings for containers and forms to let all UI

components automatically scale on different DPI settings.

Also removed the restriction to resize the MySQL for

Excel’s pane, so in case a different DPI setting is used

and the fonts look too big, the pane can be resized to

see contents as best as possible. (Bug #18099454, Bug

#71389)