You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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.