1. Chew LM
  2. Valentina Studio
  3. Dienstag, August 07 2018, 02:25 PM
  4.  Abonnieren via E-Mail
Hi,

I can't seem to execute the following create procedure in the SQL Editor.


DELIMITER ;;

CREATE PROCEDURE `GetAllPhoneBook`()
BEGIN
START TRANSACTION;
SELECT * FROM phone_book;
COMMIT;
END;;

DELIMITER ;


I got the following error:
22:21:44 Kernel error: Error( 1064 ) 42000: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DELIMITER ;;
Kommentar
There are no comments made yet.
Chew LM Akzeptierte Antwort
So that's why, it work a bit differently from what i am used to work with.
Now it make sense, thanks for explaining.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello,

Currently, it is intentional.
When you execute a query in the SQL Editor it is sent without any modification to the server, so you don't need a delimiter change here.
The server doesn't understand the DELIMITER keyword and you see the error.

A dump loader, on the other hand, splits the dump file into statements and it needs to know the delimiter.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories