[HowTo] create SQL event to truncate logs in database automatically

[hazdo]

hello mates here i am going to show you a method to truncate database logs automatically by specifaying the time to truncate
here i have select stream log table as the table i want to truncate
here is the code

To view the content, you need to Sign In or Register.

 

[Ahkan]

thank you very much

 

[tomsaywer]

hello mates here i am going to show you a method to truncate database logs automatically by specifaying the time to truncate
here i have select stream log table as the table i want to truncate
here is the code

No quote

how do you ship?

 

[hazdo]

how do you ship?

didn't get what u said?

 

[tomsaywer]

didn't get what u said?

how do i install on mysql?

 

[hazdo]

how do i install on mysql?

it is a done in mysql it is mysql syntaxe

 

[lamaindia]

This commend via ssh in mysql right

 

[trol750]

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'delimiter | CREATE EVENT `done_event` ON SCHEDULE EVERY 1 DAY ...' at line 1

 

[hazdo]

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'delimiter | CREATE EVENT `done_event` ON SCHEDULE EVERY 1 DAY ...' at line 1

To view the content, you need to Sign In or Register.

 

[nuraghi015]

any one know how to do in mariadb

hello mates here i am going to show you a method to truncate database logs automatically by specifaying the time to truncate
here i have select stream log table as the table i want to truncate
here is the code

No quote

how to do in mariadb?

 

[hazdo]

any one know how to do in mariadb

how to do in mariadb?

just my comment above your comment

 

[ayouyou]

tout le monde sait faire dans mariadb

comment faire dans mariadb?

CREATE EVENT `done_event` ON SCHEDULE EVERY 1 DAY DO TRUNCATE TABLE `xtream_iptvpro`.`stream_logs` with phpmyadmin


and to edit time

DROP EVENT `done_event`; CREATE /* DEFINER=`root`@`localhost` */ EVENT `done_event` ON SCHEDULE AT '2021-04-09 12:56:45' ON COMPLETION NOT PRESERVE ENABLE DO TRUNCATE TABLE `xtream_iptvpro`.`stream_logs`