top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to edit existing Trigger in MySQL 5.6

+1 vote

Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need
to DROP the Trigger and create a new one ? If that is the case how can you
run start command in a live environment ?

posted May 29, 2013 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+1 vote

I've created a Trigger and want to edit it. Using MySQL Workbench, I can Alter the table, and click Triggers and select the trigger action I want to edit (on my local database, MySQL running on same PC)

However, if I try the exact same procedure on a Trigger on a remote database, I don't see the Triggers under each action.

The only way these can be edited is to drop and create it again.

0 votes

I 've just created some tables that I designed using the MySQL Workbench Model. However, the database type BOOLEAN which was in my models has been converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on Windows 2008 server.

Any ideas why this has been removed ?

0 votes

The MySQL 5.7 changelog mentions:
"Beginning with MySQL 5.7.2, UPDATE_TIME displays a timestamp value for the last UPDATE, INSERT, or DELETE performed on InnoDB tables. Previously, UPDATE_TIME displayed a NULL value for InnoDB tables. For MVCC, the timestamp value reflects the COMMIT time, which is considered the last update time. Timestamps are not persisted when the server is restarted or when the table is evicted from the InnoDB data dictionary cache."

This is great news! However, I would in fact need the UPDATE_TIME to persist across database server resets. Is this feature being considered or discussed? Where might I find it online?