Possible to edit table data with MySQL Administrator?

MySQL Administrator does not provide table data-editing capabilities similar to the MySQL Control Center program it replaced in the distribution. But a package called MySQL GUI Tools includes a program called the MySQL Query Browser that enables you to work directly with the database table data through the use of SQL queries.

The MySQL GUI Tools are available for download for Windows, Macintosh and Linux, as well as in source code form. After installing the software and configuring your database connection settings, you can review and modify database table data.

To continue reading, register here and become an Insider. You'll get free access to premium content from CIO, Computerworld, CSO, InfoWorld, and Network World. See more Insider content or sign in.

Is it possible to edit MySQL database table data with MySQL Administrator? I've only been able to edit table definitions and settings.

MySQL Administrator does not provide table data-editing capabilities similar to the MySQL Control Center program it replaced in the distribution. But a package called MySQL GUI Tools includes a program called the MySQL Query Browser that enables you to work directly with the database table data through the use of SQL queries.

The MySQL GUI Tools are available for download for Windows, Macintosh and Linux, as well as in source code form. After installing the software and configuring your database connection settings, you can review and modify database table data.

When you first connect and choose a table by double-clicking its name in the table list, the program inserts a Select query in the SQL frame.When you click the Execute button, the results of the query are displayed in the program's main frame. To update records, write the appropriate SQL Insert or Update statement in the SQL frame and click the Execute button. To assist you in writing queries, a clickable SQL syntax reference guide is included.

Read more about small business networking in Network World's Small Business Networking section.