phpMyAdmin tutorial at Debconf13, part 4 : triggers/routines/events and server status monitor
Why Stack Overflow recommends it
Stack Overflow users link it to show how to set up MySQL events, routines and triggers through phpMyAdmin and how to read the Status > Monitor graphs.
Recommended by 2 people across 2 different months, 2013 to 2016.
What it is
Part 4 of a phpMyAdmin 4.0 tutorial series recorded at Debconf13, presented by developer Rouslan Placella. It explains triggers, routines and events, shows how to create and edit them in phpMyAdmin, and ends with a tour of the Server status monitor.
What people said
Recommends Marc Delisle · 2013-09 · Stack Overflow · on “Monitoring in PhpMyAdmin”
You might be able to see which queries are running from Status > Monitor, in a particular time range taken from the moving graph. See [this video] starting at 6:00.
Recommends Marc Delisle · 2013-09 · Stack Overflow · on “How to update every mysql row after specific interval of time?”
You will have to use the MySQL events. In this tutorial, you have an example of how to configure this via phpMyAdmin: [this video] .
Recommends Tata · 2015-08 · Stack Overflow · on “Error in create event query”
Then you are running create event or procedure statements via the MySQL console, you should change the delimiter first. Otherwise - it thinks that you running a list of commands and then you get this error. So to avoid this problem you should set a different delimiter. so basically your code should look like this: delimiter || CREATE EVENT `event_maid_availability` ON SCHEDULE EVERY 5 SECOND STARTS '2015-08-12 10:16:47' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN SET @t1:=1; INSERT INTO `maid_slots_availabilty`(`maid_slot_id`, `date`, `status`) SELECT maids_slots.id, DATE_ADD(CURDATE(), INTERVAL @t := @t + 1 DAY), maids_slots.status FROM (SELECT * FROM maids_slots WHERE status = '1' AND end_d
Cites CerebralDreams · 2014-09 · Stack Overflow · on “Unable to use PHPMyAdmin's Edit Routine panel for multi-line procedures”
PHPMyAdmin includes an 'add routine' and 'edit routine' panel in newer versions. The developers talked about how it could be used to write routines that are 'hundreds of lines long', but they only showed single statement routines when they were demonstrating the new features. [this video] The moment I start writing more than one statement it starts giving me syntax errors. Using semicolons doesn't help. Adding "Begin ... End" doesn't help. I just want to know how to write multiple statements in routines, functions, events, and triggers, so that I can automate my database's core functions. Edit: Jeremy Miller was able to answer my question. ( [LINK] )
Cites B 7 · 2016-07 · Stack Overflow · on “Does "Questions" means "queries" in phpMyAdmin?”
Thank you Pankaj [LINK] for your help! "Questions" means "queries"!!! As explained in this tutorial at Debconf13 on Youtube [this video]