Showing entries 11 to 20 of 32
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Excel (reset)
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.

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]
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 …

[Read more]
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.

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.

Saving and restoring Edit sessions in MySQL for Excel

Since the first release you were allowed to open a session to directly edit data from a table at Excel on a worksheet and see those changes reflected immediately on the database. You were also capable of opening multiple sessions to different tables at the same time (when they belong to the same schema). The problem was that if for any reason you were forced to close Excel or the Workbook, you had no way to reopen those sessions and continue where you left off.

Today we are going to talk about another feature included since MySQL for Excel 1.2.0 which allows you  to save and restore edit sessions. Remember this product and many others can be downloaded directly from our MySQL Installer downloads page and installed for free.

Editing MySQL connections within MySQL for Excel

Welcome to another post of the MySQL for Excel team, this time we will talk about another cool feature you can find since version 1.2.0, which can be downloaded directly from our MySQL Installer downloads page.

If you want to learn how you can easily edit connections directly from the main MySQL for Excel panel now please read this post.

If you would like to give us your feedback and propose new features you would like to see on future versions of MySQL for Excel we encourage you to please visit our forum and leave us a comment.
Thank you for your support!

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.

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 …

[Read more]
How To - Guide to appending data from Excel to an existing MySQL table

Today we're going to talk about one of the main features in MySQL for Excel. There may be times when you have a MySQL Database table that you want to add new rows to. In this blog post we're going to show you how you can do that from within Excel directly easily using the Append Excel Data to Table feature.

Always remember MySQL for Excel can be downloaded and installed directly for free, from our MySQL Installer downloads page.

Your feedback is very important for us, please drop us a message and follow our social networks:

[Read more]
Showing entries 11 to 20 of 32
« 10 Newer Entries | 10 Older Entries »