Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (128704 views)
- Error no. 2003: Can't connect... (58523 views)
- Error no. 1251: "Client does not support authentication..." (50541 views)
- Error no. 1045: "Connection denied..." (46251 views)
- SQLyog Version History (45077 views)
- Error No. 2005: Unknown MySQL server host... (33381 views)
- What is HTTP-tunneling? (32471 views)
- What Is SSH and SSH-tunneling? (28002 views)
- Why are Stored Procedures not created when I import ... (27057 views)
- Do I need PHP to use SQLyog with MySQL? ... (23936 views)
Latest FAQs 
- SQLyog Version History (2010-09-02 04:20)
- Do I need to replace the PHP tunneler file ... (2010-03-25 10:26)
- Data get truncated when importing a large CSV-file. (2010-03-18 12:30)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
Working with Views, Stored Procedures and Triggers
The "DELIMITER" command does not have effect. Why is that?
Before SQLyog version 5.17 we used a DELIMTER format like
Delimiter | ;
and not only
Delimiter |
That was unlike the MySQL command-line client, but the difference was because of the general difference of a command-line tool and a graphical editor. With a graphical editor a linebreak is "parsed away" so you must somehow tell the system that end-of-statement has been reached. You did that with the old delimiter. So the 'mysql' command line client (and other programs from MySQL AB) would not execute SQLYog DELIMITERs and vice-versa.
However from SQLyog 5.17 both formats are supported (and the 'short' one is default). We complete rewrote the parser/tokenizer component of SQLyog to enable this, so this issue should not occur anymore.
Tags: -
Related entries:
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
- Error no. 1045: "Connection denied..."
- Error no. 2003: Can't connect...
- UPPERCASE in table names are LOWERCASE'd
Last update: 2006-09-06 23:10
Author: Peter Laursen
Revision: 1.3
You can comment this FAQ