1. Fabio Yuiti Goto
  2. Valentina Studio
  3. 日, 2月 04 2018, 12:50 PM
  4.  メールで購読
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.
Ruslan Zasukhin 承諾済みの回答
This feature for SQL Editor IMPLEMENTED in 9.7.3
コメント
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.
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 承諾済みの回答
If anybody could help me with that, I'd be really thankful! ;)
コメント
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