Missing Operations Tab

[Erick Woods]

Coming from phpMyAdmin, I'm really missing the operations tab for databases and tables. You can only put so many operations in the columns for a table list of a database before it becomes cluttered with seldom used things. Please check out the operations tab in phpMyAdmin. Can rename tables, move them, alter order based on a column, set auto increment value, lots of handy stuff. Good work so far though.

[David Roth (davrot)]

Renaming of tables is already supported in table list, btw.

[Erick Woods (erickwoods)]

I didn't realize that. That's nice, but I still think it's nice to have one
"panel" where all that stuff is grouped. Altering table order it something
I use a lot. I have a lot of lookup tables and will add/delete rows in them
- delete one, add a new and the table appears out of order.

You did teach me something - moving a column within a table - I looked all
over for that years ago and could never find a solution (except to add a new
column, update it, delete original, rename new). I gave up looking for a
solution and haven't looked since. Now I see it can be done with simple
syntax. Thanks!

On Thu, Sep 22, 2011 at 8:47 AM, David Roth <email address hidden> wrote:

> Renaming of tables is already supported in table list, btw.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/825431
>
> Title:
> Missing Operations Tab
>
> Status in chive - web-based MySQL database management:
> Confirmed
>
> Bug description:
> Coming from phpMyAdmin, I'm really missing the operations tab for
> databases and tables. You can only put so many operations in the
> columns for a table list of a database before it becomes cluttered
> with seldom used things. Please check out the operations tab in
> phpMyAdmin. Can rename tables, move them, alter order based on a
> column, set auto increment value, lots of handy stuff. Good work so
> far though.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/chive/+bug/825431/+subscriptions
>

--
Erick Woods
<email address hidden>
http://www.erick.com/

[David Roth (davrot)]

I agree that a tab with the most common table operations would make sense.
Table ordering is done alphabetically regardless if it just have been altered. Or what do you mean by "appreas out of order?

Btw., don't know if you already know that, but you can move columns via drag-and drop (the blue cross icon) in the table`s column list.

[Erick Woods (erickwoods)]

By table ordering, I meant row ordering within a table. For example, if I
have rows identified by an id (1,2,3,4) and I delete row id 2, then add a
row with id 5, the actual data in the table will appear ass (1,5,3,4). The
new row uses the space formerly used by id 2, once flushed and if space
allows it. Viewing the table with a simple select, without a specific order
by, will do that. So, I will often use the phpMyAdmin dropdown to alter
table order by that id field to clean it up. That said, you DO NOT want to
add an order by to each query. You'd have to assume the default order and I
have some tables that are ordered by a date instead of the id field and are
in reverse order for a reason. I also have tables with tens of millions of
rows and adding an order by to each view would be an enormous drag on
performance.

Yes, that's how I discovered it. I move a field in a test table, then
viewed the sql for that operation. That's one thing that you have that I
love over phpMyAdmin. PMA always shows the sql used to perform an operation
at the top of the resulting page. I like how you have it available, but not
in the way.

On Thu, Sep 22, 2011 at 9:18 AM, David Roth <email address hidden> wrote:

> I agree that a tab with the most common table operations would make sense.
> Table ordering is done alphabetically regardless if it just have been
> altered. Or what do you mean by "appreas out of order?
>
> Btw., don't know if you already know that, but you can move columns via
> drag-and drop (the blue cross icon) in the table`s column list.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/825431
>
> Title:
> Missing Operations Tab
>
> Status in chive - web-based MySQL database management:
> Confirmed
>
> Bug description:
> Coming from phpMyAdmin, I'm really missing the operations tab for
> databases and tables. You can only put so many operations in the
> columns for a table list of a database before it becomes cluttered
> with seldom used things. Please check out the operations tab in
> phpMyAdmin. Can rename tables, move them, alter order based on a
> column, set auto increment value, lots of handy stuff. Good work so
> far though.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/chive/+bug/825431/+subscriptions
>

--
Erick Woods
<email address hidden>
http://www.erick.com/

[David Roth (davrot)]

Ah, I see, you mean the "ALTER TABLE ... ORDER BY ... " command, thanks for the explanation.

[Erick Woods (erickwoods)]

Exactly. After I sent that, I realized I could have been more clear.
Sorry!

On Thu, Sep 22, 2011 at 9:56 AM, David Roth <email address hidden> wrote:

> Ah, I see, you mean the "ALTER TABLE ... ORDER BY ... " command, thanks
> for the explanation.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/825431
>
> Title:
> Missing Operations Tab
>
> Status in chive - web-based MySQL database management:
> Confirmed
>
> Bug description:
> Coming from phpMyAdmin, I'm really missing the operations tab for
> databases and tables. You can only put so many operations in the
> columns for a table list of a database before it becomes cluttered
> with seldom used things. Please check out the operations tab in
> phpMyAdmin. Can rename tables, move them, alter order based on a
> column, set auto increment value, lots of handy stuff. Good work so
> far though.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/chive/+bug/825431/+subscriptions
>

--
Erick Woods
<email address hidden>
http://www.erick.com/

[Erick Woods (erickwoods)]

Found a bug in moving a column. You might know about it, but I don't have
my account to file it. Moving a DOUBLE moves it as DOUBLE (0,0) and fails.

On Thu, Sep 22, 2011 at 11:21 AM, Erick Woods <email address hidden> wrote:

> Exactly. After I sent that, I realized I could have been more clear.
> Sorry!
>
>
>
> On Thu, Sep 22, 2011 at 9:56 AM, David Roth <email address hidden>wrote:
>
>> Ah, I see, you mean the "ALTER TABLE ... ORDER BY ... " command, thanks
>> for the explanation.
>>
>> --
>> You received this bug notification because you are subscribed to the bug
>> report.
>> https://bugs.launchpad.net/bugs/825431
>>
>> Title:
>> Missing Operations Tab
>>
>> Status in chive - web-based MySQL database management:
>> Confirmed
>>
>> Bug description:
>> Coming from phpMyAdmin, I'm really missing the operations tab for
>> databases and tables. You can only put so many operations in the
>> columns for a table list of a database before it becomes cluttered
>> with seldom used things. Please check out the operations tab in
>> phpMyAdmin. Can rename tables, move them, alter order based on a
>> column, set auto increment value, lots of handy stuff. Good work so
>> far though.
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/chive/+bug/825431/+subscriptions
>>
>
>
>
> --
> Erick Woods
> <email address hidden>
> http://www.erick.com/
>

--
Erick Woods
<email address hidden>
http://www.erick.com/

[David Roth (davrot)]

Just tried to reproduce it, but it works for me.
I get a "ALTER TABLE `test`
 MODIFY `dbl` double(2, 0) NOT NULL AFTER `c`;" SQL.

Could you please fill a new bug with some more details (error message, etc.) if you can reproduce this?
Thanks.