editing records in mysql

[PushCode]

Pardon my ignorance here, but I feel like I'm missing something. I have downloaded the MySQL Administrator and MySQL Query Browser GUIs for Windows. What I really want to do is just edit records visually without having to type SQL queries. I thought for sure one of these two programs would allow me to do that, but I don't see where. I see how I can access databases ad and edit table information, but I don't see where I can go into a table and actually ad or edit a record without having to type SQL commands. Am I missing something, or is there some other free program available that will allow me to visually edit records (that is, from Windows...I don't want to use phpMyAdmin)? I can't imagine something like this doesn't exist for such a great database system as MySQL.

Any guidance would be great. Thanks!

 

[TonyGroves]

What you can do is issue a select query on a table to get a set of records (double-clicking a table will compose a suitable query for you), then click the "Edit" button at the bottom of the window and do your editing and click "Save changes" when you're finished.

 

[PushCode]

Thanks TonyGrooves,

I see now how I can do this in MySQL Query Builder. I'm assuming that it cannot be done in MySQL Administrator.

I appreciate the help.

 

[vacunita]

You might wan't to take a look at the following thread, just 2 threads down from this one:

http://www.tek-tips.com/viewthread.cfm?qid=1223974&page=1

It has a few Applications that do what you want.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[PushCode]

Thanks Vacunita.