Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
K
K
KirylLapouski2017-10-30 15:40:22
MySQL
KirylLapouski, 2017-10-30 15:40:22

Is it possible to assign a trigger to the Mysql database connection event?

How to change the values ​​in the table when connecting to the database. You need to find out what date it is today, and based on this, add the doctor on duty to the departments table.
59f71f0a5a564920758426.png

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Report
D
Dmitry Entelis, 2017-10-30
@KirylLapouski

Write a separate script, hang it in cron.

Report
R
Roman Savchuk, 2017-10-30
@WhitePerson

A cron script, as the commentator above advised.

Similar questions
A
AcidZer02015-09-20 22:33:00
Mysql query, delete all rows from a table, except for certain ones (by mask)? 1Reply
A
AcidZer02015-09-21 00:29:03
How to write mysql query correctly? 2Reply
A
Alexey Konovalov2018-01-28 17:05:27
Is there an alternative for WHERE IN? 1Reply
I
ilya_compman2010-12-04 23:51:40
MySQL MyISAM Issues - Duplicate Records and Large Table Crashes 5Reply
S
shakawkaw2015-09-22 00:22:10
How to select time-to-jump/gap extremes from MySQL? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question