Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 7

Displaying posts with tag: Office (reset)

How To - Guide to editing MySQL data within Excel
Employee +0 Vote Up -0Vote Down

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

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

  [Read more...]
MySQL for Excel 1.2.0 has been released
Employee +1 Vote Up -1Vote Down

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/.

MySQL for Excel 1.1.3 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.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
  [Read more...]
MySQL for Excel 1.1.1 GA has been released
Employee +1 Vote Up -0Vote Down

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/.

MySQL for Excel 1.1.0 GA 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.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/.

Microsoft revenues decline
+0 Vote Up -0Vote Down

It's interesting that just as Apple announced surprisingly positive quarterly results, Microsoft announced their first decline in sales revenues in 23 years.  While Microsoft is not in any kind

read more

Showing entries 1 to 7

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.