MySql

Intégrés

L’ordonnanceur est intégré dans le progiciel et ne peut être utilisé qu’à travers lui.

Accès rapide

Create an event on a table (1 reply)

Hi everyone, I'm working on an appointment scheduling system. I have an appointment table that contains appointment details, date-time and status. And I want to create an event that update the status of each appointment when its time passes. (...)

25 mai 2017
source : MySQL Forums - Events (Job Scheduler)

PREPARE STM1 syntax error (4 replies)

Hello, I want to execute the following script: SELECT @query := concat("SELECT * FROM test.station07 INTO OUTFILE 'c:/logs/test/", DATE_FORMAT(now(), '%Y_%M_%D'),".csv' FIELDS TERMINATED BY ',' (...)

14 avril 2017
source : MySQL Forums - Events (Job Scheduler)

Few Events don't run though they are enabled. (no replies)

Hi, I've around 45 Schemas in my MySQL Server instance and each schema have an event which runs every 7 minutes. I've noticed lately that few events don't run though they are enabled. There is every time a count of 2 events (...)

19 février 2017
source : MySQL Forums - Events (Job Scheduler)

Mysql schedule job to call PHP file (8 replies)

Hi, i'm a new member of forum. I've a problem with settings of a schedule event on mysql. I have to create a event that call a php file in a specific time. On web i don't find a solution at this problem. Someone knows how i can (...)

26 janvier 2017
source : MySQL Forums - Events (Job Scheduler)

How to set up Event/job schedular in MySQL (5 replies)

We need to call SP from Scheduler -- how do we set up -- I'm familiar in ETL tools -- but sure about MySQL

28 décembre 2016
source : MySQL Forums - Events (Job Scheduler)

A voir sur le net