schedule weekly mysql and php inserts

Question

schedule weekly mysql and php inserts

Navigation

#1 by (0 votes)

0

I am using php with pdo and mysql in my project I need to create schedules, breaks and the positions in which they have to be weekly, I must create 2 weeks ahead of the current week, but there are some rules: they must be ordered first by order alphabetical and they are assigned a number, and based on that list, each one is assigned breaks, timetables and positions already determined depending on the number that they played.

My question is, how can I program those insertions in mysql, I have read that it is that programmers of events are used, but I do not understand very well how to use them.

thanks.

mysql php pdo

asked by Spoke P 28.07.2017 в 06:05

source

1 answer

Jframe stuck to another Jframe Error ORA-03134: Connections to this server version are no longer supported

score 0 · Answer 1

What you need is to schedule an event in MySQL.

An event allows you to automate a task in the cron jobs style, we can define an action or a series of actions that are repeated periodically or at a specific time.

These are made from the MySQL server

I share a link to a post (It's not worthwhile to copy and paste the info that someone else already wrote) and a link to the official MySQL documentation.

Example : link

Documentation : link

I hope it serves you. Greetings.