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:
- How/when mysql compiles stored procedures?
- UPDATE column with Y or N if data exists in another table
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- How to get Python MYSQL connection username and password?
- Table is marked as crashed and should be repaired
- Coverting a .BAK file into a .SQL for use in XAMPP phpmyadmin
- Query through JSON Array with multiple values in MySQL
- Housing Society management system database structure
- MySQL DROP all tables, ignoring foreign keys
- When to use prepared statements?
- When *not* to use prepared statements?
- Are Prepared Statements a waste for normal queries? (PHP)
- Deleting rows in mysql table that contain an empty field where more complete rows exist
- MySQL given date between monday and sunday
- JSON_TABLE - how to access fields inside escaped quotes?
- mysqldump - maintain character set and collations
- Why can't a text column have a default value in MySQL?
- Using Hibernate's ScrollableResults to slowly read 90 million records
- Foreign key in the child table is null after persisting @OneToMany
- How to fix products without cover image in PrestaShop
- Laravel Eloquent Query Using Case/When to apply conditions dynamically
- MySQL SELECT a field as NULL if not existent in table
- How can I show all duplicate value from a specific column in MySQL
- Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handler declaration
- PHP mySQL - Insert new record into table with auto-increment on primary key
- IF ROW_COUNT() return error
- Date column with associated MAX count value
- Drop Column from Large Table
- MySQL - 'Using index condition' vs 'Using where; Using index'
- Conversion issues in sql - GREATEST(CEILING())