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 Jun 02, 2014

MySQL Connector/NET 6.9.1 beta has been release

Dear MySQL users,

MySQL Connector/Net 6.9.1 a new version of the all-managed .NET driver
for MySQL has been released. This is a beta release for 6.9.x and is
not recommended for production environments.

It is appropriate for use with MySQL server versions 5.5-5.7.

It is now available in source and binary form from
(note that not all mirror sites may be up to date at this point-if you
can't find this version on some mirror, please try again later or choose
another download site.)

Enjoy and thanks for the support!

On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team. 
[Read More]

Monday May 26, 2014

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

Wednesday Apr 30, 2014

MySQL Connector/NET 6.9.0 alpha has been released

Dear MySQL users,

MySQL Connector/Net 6.9.0 a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release for 6.9.x and is not recommended for production environments.

The 6.9 version of MySQL Connector/NET brings the following new features:


     * MySQL Personalization Provider.
     * SiteMap Web Provider.
     * Simple Membership Web Provider.

Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

[Read More]

Friday Apr 25, 2014

What's new on MySQL for Visual Studio 1.2.0 alpha, part one

MySQL for Visual Studio 1.2.0 was just released the last week. In this post we will make a quick introduction on what's coming up in this new version. [Read More]

Tuesday Apr 22, 2014

MySQL for Visual Studio 1.2.0 alpha has been released

MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.0 version is an alpha release of this product that intents to introduce users to the new features in this version.[Read More]

Wednesday Apr 09, 2014

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!

[Read More]

Friday Apr 04, 2014

MySQL Connector/NET 6.7.5 has been released

Dear MySQL Users,

MySQL Connector/NET 6.7.5, a new version of the all-managed .NET driver for MySQL has been released.  This is a Maintenance release. It is recommended for production environments.  It is appropriate for use with MySQL server versions 5.0-5.7.

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

Also Nuget packages are available:





The documentation is available at:


Enjoy and thanks for the support!

On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

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

Tuesday Mar 18, 2014

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:
Cheers!
[Read More]

Tuesday Mar 11, 2014

HowTo: MySQL new toolbar inside the Visual Studio IDE

MySQL for Visual Studio 1.1.4 was released including a new feature: MySQL Toolbar inside the Visual Studio environment. This post will cover the details on this new feature.[Read More]

Monday Mar 10, 2014

MySQL for Visual Studio 1.1.4 is available for download

MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. Today we're releasing the 1.1.4 Maintenance Release of this product. It is a version suitable for production environments, compatible with Connector/Net 6.8.3 or further versions and supports MySQL server versions 5.0 to 5.6.[Read More]

Sunday Mar 09, 2014

How To - Guide to exporting data from Excel to a new MySQL table

There may be times when you need to create a new table in MySQL and feed it with data from another database, the Internet or from combined data sources. MS Excel is commonly used as the bridge between those data sources and a target MySQL database because of the simplicity it offers to organize the information to then just dump it into a new MySQL table. Although the last bit sounds trivial, it may actually be a cumbersome step, creating ODBC connections within Excel through Microsoft Query may not help since these are normally created to extract data from MySQL into Excel, not the opposite. What if you could do this in a few clicks from within Excel after making your data ready for export to a MySQL database?

With MySQL for Excel you can do this and this guide will teach you how easy it is.

[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
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today