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.
https://www.youtube.com/watch?v=7ZRZoCsrKis
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. (https://stackoverflow.com/a/25905326/4052662)
I had to upgrade my PHPMyAdmin which meant upgrading MySQL, so... now for the answer. When I tried this using a test routine, I kept getting errors, but fortunately the dialog showed the created query. I believe what you're missing is adding in BEGIN and END (if you did what I did).
I took a screen shot of what worked, though, so hoping this gets you going:
- System.NotSupportedException: Character set 'utf8mb3' is not supported by .Net Framework
- Enabling MySQL general query log with JDBC
- Join two tables where one table name is inside the other table
- Unable to make a remote api call to flask app(for MySQL connection) inside my apache server
- How can I set a numeric wildcard in MySQL?
- Your password does not satisfy the current policy requirements
- Weighted hierarchical cumulative sum
- MySql views performance
- Are MySql Views Dynamic and Efficient?
- Storing 2 same id of post table with different language into database
- Using multiple tables for lookup in MySQL
- mysql change innodb_large_prefix
- findAll() in Sequelize doesn't find a row created inside a transaction
- Unable to connect from MySQL Workbench to AWS RDS instance
- Spring Boot JPA MySQL : Failed to determine a suitable driver class
- How to count the number of groups of events that are more than 20 minutes from each other?
- How to properly save a complex object using EF Core
- Select query in MySQL
- Same table union from different databases
- How to generate a UUIDv4 in MySQL?
- Whats wrong with my query with CASE statement
- Select All Events with Event->Schedule->Date between start and end dates in CakePHP
- Insert custom date into mysql timestamp field
- Filtering mysql data using nested json_table returns "Incorrect arguments"
- How to fix "Error executing DDL "alter table events drop foreign key FKg0mkvgsqn8584qoql6a2rxheq" via JDBC Statement"
- Directus is not connecting with mysql over SSH server
- Inserting and selecting UUIDs as binary(16)
- How to fix Authentication method caching_sha2_password not supported by any of the available plugins in Visual Studio
- exception emyxerror in module mysqlquerybrowser exe at 00111E52
- Efficiently Querying Nearby Warehouses Based on Latitude and Longitude Within a Specified Radius