How to scheduled MYSQL query on a defined fixed time?


Problem :

Hi i have a my mysql table where i want to run mysql query daily at scheduled time

my query is

truncate  dashboard

I need to run the query everyday, at 6:00 PM.

How can i achieve this

Any help will be appreciated



Solution :

Create a schedule:

CREATE EVENT my_event
  ON SCHEDULE
    EVERY 1 DAY
    STARTS '2014-09-13 18:00:00'
      ON COMPLETION PRESERVE ENABLE 
  DO BEGIN
    TRUNCATE dashboard;
  END

Mysql Tutorials

Mysql Howto..

Not sure how to do ajax functions inside of javascript to get to mysql

How do I build libmySQL?

How to convert date YYYYMMDD to YY-MM-DD in MySQL query

MySQL Query how to show opposite results

How to 'append' a mysql column onto another

How to do join with multiple conditions in mysql

How to order by multiple fields in MySQL?

MySQL - How to recieve table of substrings from string

How to search with firstname and last name in - Mysql

Poor Performance from MySQL JOIN - How to Make Improvements?

How to link a mysql record and a MongoDB document?

How to compare an input image from user with a stored image on the database in C# [closed]

mysql how do I change the column id from varchars to ints and autoincreasing?

MySQL Innodb Deadlock - how to remove old event?

How can I select out parameters in a MySQL procedure as table columns?

How to sort mysql search result by relevance?

how to add hours ,minutes or seconds in 'TIME' Datatype in mysql

How to select longitude, latitude around specifc location from mysql?

how to hide smth with PHP if there is a specific variable or word in the list

How to replace output of SELECT statemnt in Mysql?

How to display date in mysql TIMESTAMP?

How to terminate a query that is displayed in Session Monitor in Toad for MySQL

How to select all distinct values except one in MySQL?

How to insert random numbers MySql

MySQL: How do I pad out table to fill missing rows with existing data

How To Fetch Random Row From MySQL Database Table Without Numeric ID?

How to handle/optimize thousands of different to executed SELECT queries?

How to count the total amount of rows in a mysql database using VB

Mysql how to get all rows from a table that the a field not having the particular value..?

COCOA Objective-c : How can connect to mysql database?