1. Fabio Yuiti Goto
  2. Valentina Studio
  3. Воскресенье, Февраль 04 2018, 12:50 PM
  4.  Подписаться через 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?
Комментарий
There are no comments made yet.
Fabio Yuiti Goto Ответ принят
If anybody could help me with that, I'd be really thankful! ;)
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Fabio Yuiti Goto Ответ принят
Oh, thanks! :)

I'll keep that when using the editor then. ;)
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
This feature for SQL Editor IMPLEMENTED in 9.7.3
Комментарий
There are no comments made yet.
  • Страница :
  • 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