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.

 

[maverick]

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

that's how it's supposed to be...

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

 

[hazdo]

that's how it's supposed to be...

No quote

it depends on the database used its version and the system used to interact with database because i am using it and it works with me
also read mysql website they used this method

 

[maverick]

it depends on the database used its version and the system used to interact with database because i am using it and it works with me
also read mysql website they used this method

if we are talking about the xtream UI in ubuntu 18 it has to be like this