Vote count:
1
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.
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.
asked 2 mins ago
Unable to use PHPMyAdmin's Edit Routine panel for multi-line procedures
Begin and End works for me
RépondreSupprimerHere's a screenshot of a routine creation that worked just fine
http://imgur.com/whiitpg
Only just realised that this is a splog. Oh well
RépondreSupprimer