Feature to show table status

32 views
Skip to first unread message

Bob Siefkes

unread,
Feb 6, 2012, 8:26:44 AM2/6/12
to Sequel Pro
I'm just arriving from the windows 7 world and used to use heidisql
which is unfortunately not available for mac. Two things i'm really
missing:

[1] show a list of tables in the content windows with the update_time
so it;'s easy to analyse which table is modified when I do something
in the application. This van be done with: show table status
[2] I would prefer a CONFIRM button before changes of table
definitions are applied. It's very easy to accedentilly change a
setting without knowing.
[3] I prefer the heidisql way of filtering by just right click the
field and choose for the filter type. And sequelpro seems also not to
support multiple filter conditions although this might be there and
the I will have missed it.

Performance wise it's very good and appreciated and my impressions are
just mentioned for continuesly improvements...

Bob Siefkes

unread,
Feb 7, 2012, 2:34:52 AM2/7/12
to Sequel Pro
I found a workable solution for the moment to show the table list of
the current database with the most recent updated tables on top.

I made this query and store it as a global favorite:
SELECT update_time, t.* FROM information_schema.tables t WHERE
table_schema = DATABASE() order by update_time desc;

Two remarks:
The field update_time will show twice but I don't care, as long as
it's within visible display which was not the case.
The update_time is avaiable for mysisam but not for innodb, this is
nature of mysql.

I use this method often to quickly see the impacted tables when I do
perform an action in a web application. E.g. enter new product in
backoffice of a (unknown) application and then check the updated
tables with this query.
Reply all
Reply to author
Forward
0 new messages