Bug, probably

philip_38's profile image philip_38 posted 5 years ago in General Permalink

I connect to mariadb 10.4, click on a stored procedure, then I click on create code, copy everything, connect to another box, open a query windows, paste the code, run the query, and it fails. It says incorrect syntax at line 16. Please try it. So how do I transfer a stored procedure from a development box to a production box? Philip

ansgar's profile image ansgar posted 5 years ago Permalink

The CREATE code of a procedure probably contains compound statements, so you will need to tell HeidiSQL to use a different query delimiter than semicolon:

Description

Please login to leave a reply, or register at first.