1. Fabio Yuiti Goto
  2. Valentina Studio
  3. Sunday, February 04 2018, 12:50 PM
  4.  Subscribe via email
Hi!

I kinda used some basic SQL for some time, but now I'm studying it a bit more, and I'm using Valentina as my main learning tool.

I've been having some problems whenever I use the DELIMITER keyword or import any *.sql file that includes that keyword.

For example, this throws a Kernel error in Valentina Studio:

DELIMITER |
SHOW TABLES;
|
DELIMITER ;


Using it on command line or on clients like HeidiSQL or PHPMyAdmin, it runs just fine. To make it run on Valentina, I'll have to delete the delimiters, is this a bug, it's intented to be that way? And does that mean I'll have to delete delimiters from all my SQL files?
Comment
There are no comments made yet.
Fabio Yuiti Goto Accepted Answer
If anybody could help me with that, I'd be really thankful! ;)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
Hello Fabio,

Currently, we don't support DELIMITER command in the SQL Editor, only in the dump loader.

The query is sent as is without any modification.

DELIMITER is not the SQL command, it is not recognized by the server, and you see this error.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Fabio Yuiti Goto Accepted Answer
Oh, thanks! :)

I'll keep that when using the editor then. ;)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Ruslan Zasukhin Accepted Answer
This feature for SQL Editor IMPLEMENTED in 9.7.3
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
  • Page :
  • 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