【mysql】navicat模拟事务

show variables like 'autocommit';

set autocommit = 0;

BEGIN;
UPDATE daily_active_user
SET count = 1
WHERE
    create_time BETWEEN DATE_FORMAT(
        '2022-02-14 00:00:00',
        '%Y-%m-%d %H:%i:%S'
    )
AND DATE_FORMAT(
    '2022-02-14 23:59:59',
    '%Y-%m-%d %H:%i:%S'
);
COMMIT;

set autocommit=on;