Monday Mar 09, 2015

MySQL for Excel 1.3.4 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.4. This is a maintenance release for 1.3.x. It can be used for production environments.

MySQL for Excel is installed using the MySQL Installer for Windows which 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 MySQL for Excel over the web and install it when run.

You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/. The MySQL for Excel product can also be downloaded by using the product standalone installer found at this link http://dev.mysql.com/downloads/windows/excel/

Several new features were added the 1.3.x branch, for more information see What Is New In MySQL for Excel 1.3 (http://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-what-is-new-1-3.html).

[Read More]

Tuesday Oct 28, 2014

MySQL for Excel 1.3.3 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.3. This is a maintenance release for 1.3.x. It can be used for production environments.

MySQL for Excel is installed using the MySQL Installer for Windows which 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 MySQL for Excel over the web and install it when run.

You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/. The MySQL for Excel product can also be downloaded by using the product standalone installer found at this link http://dev.mysql.com/downloads/windows/excel/

Several new features were added the 1.3.x branch, for more information see What Is New In MySQL for Excel 1.3 (http://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-what-is-new-1-3.html).

[Read More]

Wednesday Jul 02, 2014

MySQL for Excel 1.3.1 RC has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.1.  This is a RC release for 1.3.x.

As this is a Release Candidate version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/

Your feedback on this release candidate version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.

[Read More]

Thursday Jun 26, 2014

Optimistic updates for Edit Data operations in MySQL for Excel

In this blog post regarding MySQL for Excel features included since version 1.2.0, we are going to talk about a new option that is used along with Edit MySQLData operations; very useful when editing data in a multi-user environment. If you are not familiar with editing MySQL data it is very advisable that you visit our thorough blog post about that topic: How To - Guide to editing MySQL data within Excel.

Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.  

[Read More]

Tuesday Jun 17, 2014

SQL queries preview before sent to server in MySQL for Excel

In this blog post we are going to cover a pretty useful piece of functionality introduced since MySQL for Excel 1.2.0.

There could be times when users may want to see exactly what SQL queries are being generated either before they are sent to the server, so corrections can be made if the query does not look as intended, or after they are sent to the server to obtain additional information or for debugging purposes.

Starting with MySQL for Excel 1.2.0, new global options were added to modify the behavior of the moment when SQL queries that affect a MySQL database are shown to the users. The Global Options dialog can be accessed from the Options button located in the Schema Selection panel or the DB Objects Selection one as shown below.

Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.

[Read More]

Monday Jun 09, 2014

MySQL for Excel 1.3.0 Beta has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.0.  This is a beta release for 1.3.x.

As this is a beta version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/

Your feedback on this beta version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.

[Read More]

Friday Jun 06, 2014

Excel tables creation upon importing MySQL data in MySQL for Excel

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.2.0, we introduced some advanced options for the Import MySQL Data operation regarding Excel tables. You can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.

[Read More]

Monday Mar 31, 2014

How To - Guide to editing MySQL data within Excel

In previous posts we have talked about importing data from MySQL to Excel, exporting data from Excel to a new or to a existing MySQL table (via the Export Data or Append Data operations) which are common tasks to be performed against MySQL tables. In this post we will talk about possibly the coolest feature in MySQL for Excel which is the Edit Data operation which allows the retrieval of a MySQL table's data to an Excel worksheet so the data can be edited, deleted or inserted in new rows and those changes saved back to the MySQL database in a friendly and intuitive way, and more importantly, without the need of writing SQL queries making it accessible to any kind of user.

You will learn in this guide how to do it and all the details about the Edit Data feature in MySQL for Excel.

[Read More]

Thursday Mar 27, 2014

MySQL for Excel 1.2.1 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.

MySQL for Excel 1.2.1 is a maintenance release for 1.2.x containing a handful of bug fixes and the following minor features:

  • When MySQL Workbench is not installed, MySQL connections are now automatically created for discovered MySQL services. If MySQL Workbench is later installed, these connections are not migrated over to MySQL Workbench as MySQL Workbench also creates connections for discovered MySQL services.

You can download MySQL for Excel 1.2.1 from our official Downloads page at http://dev.mysql.com/downloads/windows/excel as a standalone MSI, and it will be available shortly in the MySQL Installer for Windows that can be downloaded from http://dev.mysql.com/downloads/installer/.

[Read More]

Friday Jan 31, 2014

MySQL for Excel 1.2.0 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.0, the  latest addition to the MySQL Installer for Windows.

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. You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

[Read More]

Wednesday Oct 16, 2013

MySQL for Excel 1.1.3 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.3, the  latest addition to the MySQL Installer for Windows.

MySQL for Excel 1.1.3 is a maintenance release containing a handful of bug fixes and the following minor features:

  • Upon saving a Workbook containing Worksheets in Edit Mode, the user is asked if he wants to exit the Edit Mode on all Worksheets before their parent Workbook is saved so the Worksheets are saved unprotected, otherwise the Worksheets will remain protected and the users will be able to unprotect them later retrieving the passkeys from the application log after closing MySQL for Excel.
  • Added background coloring to the column names header row of an Import Data operation to have the same look as the one in an Edit Data operation (i.e. gray-ish background).
  • Connection passwords can be stored securely just like MySQL Workbench does and these secured passwords are shared with Workbench in the same way connections are.
  • Changed the way the MySQL for Excel ribbon toggle button works, instead of just showing or hiding the add-in it actually opens and closes it.
  • Added a connection test before any operation against the database (schema creation, data import, append, export or edition) so the operation dialog is not shown and a friendlier error message is shown.

MySQL for Excel is installed using the MySQL Installer for Windows. You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

[Read More]

Friday Apr 26, 2013

MySQL for Excel 1.1.1 GA has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.1 GA, the  latest addition to the MySQL Installer for Windows.

MySQL for Excel 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

Version 1.1.1 is a maintenance release containing a handful of bug fixes.

You can download it from our official Downloads page at http://dev.mysql.com/downloads/installer/.

[Read More]

Thursday Oct 18, 2012

MySQL for Excel 1.1.0 GA has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.0 GA, one of our newest products contained in the MySQL Installer suite.  This new version introduces the Edit MySQL Data feature.

You can download it from our official Downloads page at http://dev.mysql.com/downloads/installer/.

[Read More]
About

Here's where you'll hear about all the new and fun stuff we are doing with MySQL on Windows.

Search

Categories
Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today