Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 27 Next 10 Older Entries

Displaying posts with tag: Excel (reset)

Refreshing imported MySQL data with MySQL for Excel
Employee +1 Vote Up -0Vote Down

Welcome to another blogpost from the MySQL for Excel Team. This time we're going to talk about a new feature included since MySQL for Excel 1.3.0, now we maintain the link between imported Excel tables and its data source. Now, with this new feature we'll show you how easy is to work with the latest available information at all times.

We would like to remind you, our latest GA or maintenance version can be installed using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer



  [Read more...]
Collation options for new MySQL schemas and tables created in MySQL for Excel
Employee +0 Vote Up -0Vote Down

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, MySQL for Excel has always let you create new schemas and tables in a MySQL database, in versions lower than 1.3.0 these were created with the default character set and collation defined in the MySQL server. Starting with version 1.3.0 we introduced several features regarding collations:

  • New drop-downs were added that let you to override the default collation for new MySQL schemas and tables.
  • Default collations for each schema can be shownin the schemas list below the schema names.
  • The SQL queries for schemas creation can be previewed or displayed (depending on its global setting).

Remember you can install the latest

  [Read more...]
Resetting advanced options to defaults in MySQL for Excel
Employee +1 Vote Up -0Vote Down

Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since 1.3.0, remember you can always install the latest GA or maintenance version using the MySQL Installer also you can download directly any GA or non-GA version from the MySQL Developer Zone.

In this post we will learn how to reset several advanced options to their default values.



Remember that your feedback is very important for us, please drop us a message with your comments, suggestions for this or other



  [Read more...]
Showing all available MySQL data types when creating a new table with MySQL for Excel
Employee +1 Vote Up -0Vote Down

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, a new advanced option was added to the Export Data dialog to show all available MySQL data types on its Data Type combo-box to override its default behavior that shows only the most commonly used data types.

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.

Adding summary fields when importing MySQL data with MySQL for Excel
Employee +0 Vote Up -0Vote Down

Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since 1.3.0, remember you can always install the latest GA or maintenance version using the MySQL Installer also you can download directly any GA or non-GA version from the MySQL Developer Zone.

In this post we will learn how to add summary fields to our data imports to excel easily.



Remember that your feedback is very important for us, please drop us a message with your comments, suggestions for this or other features and



  [Read more...]
MySQL for Excel 1.3.1 RC has been released
Employee +0 Vote Up -0Vote Down

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
Employee +0 Vote Up -0Vote Down

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.  

SQL queries preview before sent to server in MySQL for Excel
Employee +3 Vote Up -0Vote Down

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

  [Read more...]
MySQL for Excel 1.3.0 Beta has been released
Employee +2 Vote Up -0Vote Down

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
Employee +0 Vote Up -0Vote Down

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.

Showing entries 1 to 10 of 27 Next 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.