Professional Web Applications Themes

Cannot edit table data in mysql Administrator (GUI) - MySQL

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

  1. #1

    Default Re: Cannot edit table data in mysql Administrator (GUI)

    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.
    Bill Karwin Guest

  2. #2

    Default Re: Cannot edit table data in mysql Administrator (GUI)

    darius wrote:
    > Bill Karwin <billkarwin.com> wrote in
    > news:ecieop01md3enews1.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).

    --

    Murdoc Guest

  3. #3

    Default Re: Cannot edit table data in mysql Administrator (GUI)

    darius wrote:
    > "Murdoc" <murdoc_0hotmail.com> wrote in
    > news:xn0eqfnvr1808w000news-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.
    Bill Karwin Guest

  4. #4

    Default Re: Cannot edit table data in mysql Administrator (GUI)

    On Sun, 27 Aug 2006 12:02:59 -0700, Bill Karwin <billkarwin.com>
    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
    Lee Peedin Guest

Similar Threads

  1. Replies: 0
    Last Post: June 1st, 03:15 AM
  2. can't edit - administrator is
    By elfinstar in forum Macromedia Contribute Connection Administrtion
    Replies: 1
    Last Post: December 23rd, 04:38 AM
  3. Replies: 4
    Last Post: October 27th, 03:01 PM
  4. [PHP] Displaying MySQL data inside of a table
    By Jacob Vennervald Madsen in forum PHP Development
    Replies: 3
    Last Post: July 28th, 03:49 PM
  5. Displaying MySQL data inside of a table
    By Sp Computing in forum PHP Development
    Replies: 0
    Last Post: July 28th, 02:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139