Cannot edit table data in mysql Administrator (GUI)

[Database Administrator]

Hello,

Using mysql administrator 1.1.9 (GUI), I can edit table but I cannot edit
table data (option is always disabled). I've granted myself all
privileges to said table. using mysql 4.1.18. I have to use the
commandline tool and do all views and edits by sql, which is kind of a
pain. what am I doing wrong? thanks

[Database Administrator]

darius wrote:
> Hello,
>
> Using mysql administrator 1.1.9 (GUI), I can edit table but I cannot edit
> table data (option is always disabled). I've granted myself all
> privileges to said table. using mysql 4.1.18. I have to use the
> commandline tool and do all views and edits by sql, which is kind of a
> pain. what am I doing wrong? thanks

You need to also install MySQL Query Browser to edit table data. Then
the option in Administrator won't be grayed out.

By the way, there are newer versions of QB and Administrator available,
and now they're bundled together as one installable package, along with
MySQL Workbench, MySQL's ER modelling tool.

Regards,
Bill K.

[Database Administrator]

Bill Karwin wrote in
news:ecieop01md3@enews1.newsguy.com...

> You need to also install MySQL Query Browser to edit table data.
> Then the option in Administrator won't be grayed out.
>
> By the way, there are newer versions of QB and Administrator
> available, and now they're bundled together as one installable
> package, along with MySQL Workbench, MySQL's ER modelling tool.
>

thanks, that made my life so much easier!!

[Database Administrator]

Bill Karwin wrote in
news:ecieop01md3@enews1.newsguy.com...

> By the way, there are newer versions of QB and Administrator
> available, and now they're bundled together as one installable
> package, along with MySQL Workbench, MySQL's ER modelling tool.
>

Maybe I spoke too soon. I downloaded mysql admin v 1.2.2 with QB, and
though I can browse tables, all edit options are greyed out -- delete
row, add row, clear field, load field, edit field in popup editor. What
do I need to do?

[Database Administrator]

darius wrote:

> Bill Karwin wrote in
> news:ecieop01md3@enews1.newsguy.com...
>
> > By the way, there are newer versions of QB and Administrator
> > available, and now they're bundled together as one installable
> > package, along with MySQL Workbench, MySQL's ER modelling tool.
> >
>
> Maybe I spoke too soon. I downloaded mysql admin v 1.2.2 with QB, and
> though I can browse tables, all edit options are greyed out -- delete
> row, add row, clear field, load field, edit field in popup editor. What
> do I need to do?

Did you switch the query results section to "Edit" mode? There's a button labeled Edit on the bottom of the data grid (next to the xx rows returned in xx seconds).

--

[Database Administrator]

"Murdoc" wrote in
news:xn0eqfnvr1808w000@news-south.connect.com.au...

> Did you switch the query results section to "Edit" mode? There's a
> button labeled Edit on the bottom of the data grid (next to the xx
> rows returned in xx seconds).

I'm a moron. sorry!

[Database Administrator]

darius wrote:
> "Murdoc" wrote in
> news:xn0eqfnvr1808w000@news-south.connect.com.au...
>
>> Did you switch the query results section to "Edit" mode? There's a
>> button labeled Edit on the bottom of the data grid (next to the xx
>> rows returned in xx seconds).
>
> I'm a moron. sorry!

FWIW, I've been developing software on computers for 26 years, and I
have yet to find a single system that is "intuitive". *Nothing* about
computers is intuitive as far as I'm concerned. So there's no need to
criticize yourself! :-)

Also note that you can only use edit mode on tables in MySQL QB if you
the table has a primary key, and you display the data in the results
grid including that primary key.

Regards,
Bill K.

[Database Administrator]

On Sun, 27 Aug 2006 12:02:59 -0700, Bill Karwin
wrote:

>Also note that you can only use edit mode on tables in MySQL QB if you
>the table has a primary key, and you display the data in the results
>grid including that primary key.
>
>Regards,
>Bill K.

Bill,
Thank's for including the above statement in your last post. I had
read and tried everything I could find on the edit mode and had yet to
see the disclaimer you pointed out. I am very new to MySQL and was a
bit reluctant to show my ignorance just yet, so I just kept reading.
After seeing your statement above I went back to my "test" table and
added a primary key. I can now edit the data.

Thanks
Lee

[vallavanoo7]

thank you sir...
every word of urs is perfect...