def |
sys |
sys_config_insert_set_user |
INSERT |
def |
sys |
sys_config |
1 |
NULL
|
BEGIN
IF @sys.ignore_sys_config_triggers != tr...
|
ROW |
BEFORE |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:09:30.40 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sys |
sys_config_update_set_user |
UPDATE |
def |
sys |
sys_config |
1 |
NULL
|
BEGIN
IF @sys.ignore_sys_config_triggers != tr...
|
ROW |
BEFORE |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:09:30.40 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
mysql.sys@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sakila |
ins_film |
INSERT |
def |
sakila |
film |
1 |
NULL
|
BEGIN
INSERT INTO film_text (film_id, title, d...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:22:08.08 |
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... |
root@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sakila |
upd_film |
UPDATE |
def |
sakila |
film |
1 |
NULL
|
BEGIN
IF (old.title != new.title) or (old.desc...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:22:08.09 |
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... |
root@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sakila |
del_film |
DELETE |
def |
sakila |
film |
1 |
NULL
|
BEGIN
DELETE FROM film_text WHERE film_id = ol...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:22:08.11 |
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... |
root@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sakila |
customer_create_date |
INSERT |
def |
sakila |
customer |
1 |
NULL
|
SET NEW.create_date = NOW()
|
ROW |
BEFORE |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:22:09.07 |
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... |
root@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sakila |
payment_date |
INSERT |
def |
sakila |
payment |
1 |
NULL
|
SET NEW.payment_date = NOW()
|
ROW |
BEFORE |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:22:11.19 |
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... |
root@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
sakila |
rental_date |
INSERT |
def |
sakila |
rental |
1 |
NULL
|
SET NEW.rental_date = NOW()
|
ROW |
BEFORE |
NULL
|
NULL
|
OLD |
NEW |
2019-10-30 15:22:12.62 |
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... |
root@localhost |
utf8mb4 |
utf8mb4_0900_ai_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Parks_AFTER_INSERT |
INSERT |
def |
klo |
Parks |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.32 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Parks_AFTER_UPDATE |
UPDATE |
def |
klo |
Parks |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.39 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Parks_AFTER_DELETE |
DELETE |
def |
klo |
Parks |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.46 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
RentalPoints_AFTER_INSERT |
INSERT |
def |
klo |
RentalPoints |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.51 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
RentalPoints_AFTER_UPDATE |
UPDATE |
def |
klo |
RentalPoints |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.56 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
RentalPoints_AFTER_DELETE |
DELETE |
def |
klo |
RentalPoints |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.61 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Vehicles_AFTER_INSERT |
INSERT |
def |
klo |
Vehicles |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.65 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Vehicles_AFTER_UPDATE |
UPDATE |
def |
klo |
Vehicles |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.71 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Vehicles_AFTER_DELETE |
DELETE |
def |
klo |
Vehicles |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.75 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Rentals_AFTER_INSERT |
INSERT |
def |
klo |
Rentals |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.80 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Rentals_AFTER_UPDATE |
UPDATE |
def |
klo |
Rentals |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.84 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Rentals_AFTER_DELETE |
DELETE |
def |
klo |
Rentals |
1 |
NULL
|
BEGIN
DECLARE user_name VARCHAR(50);
SEL...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.92 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |
def |
klo |
Check_Vehicle_Count |
DELETE |
def |
klo |
Vehicles |
2 |
NULL
|
BEGIN
DECLARE vehicle_count INT;
SELECT ...
|
ROW |
AFTER |
NULL
|
NULL
|
OLD |
NEW |
2024-06-24 15:19:48.99 |
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... |
root@192.168.30.% |
utf8mb4 |
utf8mb4_unicode_ci |
utf8mb4_0900_ai_ci |