Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
29 views

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE ...
1
vote
1answer
29 views

How to update MySQL data within intranet from MySQL data in cloud?

I am currently using a MySQL DB located within the intranet. Only the people within the LAN can access the information. I'm trying to re-create the MySQL DB in a cloud provider. This can be accessed ...
1
vote
1answer
724 views

Scheduling an event every day at a given time

I want my event to run everyday at 00:20. I am confused in scheduling of the time. Should I be using the first option or the second one? Option 1 CREATE EVENT my_event ON SCHEULE EVERY 1 DAY ...
1
vote
1answer
723 views

column auto updated after 24 hours in mysql

i have a table T1 with column : Name State time mon 1 2014-01-09 11:23:00 tue 0 2014-01-07 14:40:00 wed 2 2014-01-08 09:23:00 thu ...
0
votes
1answer
735 views

Where EVENTS history are logged/recorded in MySql?

I just setup some stored procedures to run in the event scheduler using CREATE EVENT. I'm trying to find where (if somewhere) the history of it running is stored. I looked at the docs but couldn't ...
0
votes
1answer
935 views

Seting timezone per database in MySQL

I wanted to know if MySQL let the admin set a timezone per database ? I have three different databases for three different customers. Each of them being in their own timezone. I would like to load ...