I need to run an alter with Percona tool but it gives error:
The table
gts
.xml_bookings
has triggers. This tool needs to create its own triggers, so the table cannot already have triggers
So I checked the triggers like this:
show triggers like 'xml_bookings'\G;
output:
Trigger: booking_status_update2
Event: UPDATE
Table: xml_bookings
Statement: BEGIN
IF (OLD.backofficestatus <> NEW.backofficestatus
AND left(OLD.booktime,10) <> curdate()) THEN
insert into booking_status_changes
set processid=new.processid,
oldstatus=OLD.backofficestatus,
newstatus=NEW.backofficestatus,
website=NEW.website;
END IF;
END
Timing: BEFORE
Created: NULL
sql_mode:
Definer: root@localhost
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
1 row in set (0.00 sec)
ERROR: No query specified
What are the options I have? Eventually I need to use pt-online-schema-change
to altering.
OR
, notAND
??OR
is needed, notAND
. (English is ambiguous on the meaning of "and", but SQL is not.)