Small Business Networking
Subscribe to this site with RSS
Possible to edit table data with MySQL Administrator?
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.
| Use this form to start a public discussion with other Linux World users on this article. Log In | Register for an account (Why you should) |
Note: Register to have your user name appear; otherwise your comment will show up as "Anonymous."
*Anonymous comments will only appear once they are approved by the moderator.
• Dell puts Linux and Atom in Vostro PCs
• Mozilla names best Firefox 3 add-ons
• Torvalds: Fed up with the 'security circus'
• Dell Latitude ON - big win for Linux
• Open source advocates hail appeals court ruling
LinuxWorld Conference and Expo San Francisco, August 4-7, 2008.
Linux Plumbers Conference Portland, OR, Sept. 16-19, 2008.
FreedomHEC Santa Monica, November 8-9, 2008.
Featured Whitepapers
| The Trend from UNIX to Linux in SAP(r) Data Centers |