Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Bug, probably

philip_38's profile image philip_38 posted 1 month 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 1 month 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:


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