INSERT into Newest_log_operation (
ACTION, operation, Key_value, Bus_key, CONTENT, user_id, VERSION, Module,create_time)
VALUES (: Action,: Operation,: KeyValue,: Buskey,: Content,: UserId, 1,: Module,now ())
On DUPLICATE KEY UPDATE
Action = values (action), operation = VALUES (operation), Bus_key = VALUES (bus_key), content = values (content),
USER_ID = VALUES (user_id), Version = version + 1,create_time = VALUES (create_time);
1.ON DUPLICATE key UPDATE: Indicates unique key repetition or primary key duplication
2.VALUES (: Action,: Operation,: KeyValue,: Buskey,: Content,: UserId, 1,: Module,now ()): If no value exists, the record is added and the value is assigned
3.ACTION = VALUES (ACTION), operation = VALUES (operation), Bus_key = VALUES (bus_key), content = values (content),
USER_ID = VALUES (user_id), Version = version + 1,create_time = VALUES (create_time): Indicates that a partial field is updated if the unique or primary key already exists.
MySQL exists on the update, does not exist on the new