Re: [Maria-discuss] TRIGGERing on new users

2017-07-07 Thread Curtis Brown
:) Thank you Guillaume. I think this will help me out. Have a good weekend! On Fri, 2017 Jul 07, 15:18:36 (+), Guillaume Lefranc wrote: > Hi Curtis, > > yes MariaDB has the function to schedule events internally, check SHOW > EVENTS, CREATE EVENT, etc. > > Cheers, > GL > > Le ven. 7 juil. 2

Re: [Maria-discuss] TRIGGERing on new users

2017-07-07 Thread Guillaume Lefranc
Hi Curtis, yes MariaDB has the function to schedule events internally, check SHOW EVENTS, CREATE EVENT, etc. Cheers, GL Le ven. 7 juil. 2017 à 16:33, Curtis Brown a écrit : > Hi Guillaume! Thank you for bringing some ideas to mind. When you said > "set up an event which runs regularly", were y

Re: [Maria-discuss] TRIGGERing on new users

2017-07-07 Thread Curtis Brown
Hi Guillaume! Thank you for bringing some ideas to mind. When you said "set up an event which runs regularly", were you thinking of a cron job or some similar cron-like functionaility in MariaDB/MySQL, or something else? Can you elaborate? On Fri, 2017 Jul 07, 10:22:28 (+0200), Guillaume Lefranc

Re: [Maria-discuss] TRIGGERing on new users

2017-07-07 Thread Guillaume Lefranc
Hi Curtis, two different solutions come to mind. You could wrap your user creation in a stored procedure that does all the heavy lifting: create the user and perform the additional functions Or, you could set up an event which runs regularly, checks if new users have been added, and if that is t