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
- SQL Scheduler and Reporting Tool
- 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
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (169222 views)
- Error no. 2003: Can't connect... (86215 views)
- SQLyog Version History (63912 views)
- Error no. 1045: "Connection denied..." (61323 views)
- Error no. 1251: "Client does not support authentication..." (58308 views)
- Error No. 2005: Unknown MySQL server host... (50162 views)
- What is HTTP-tunneling? (42269 views)
- What Is SSH and SSH-tunneling? (38047 views)
- Can I use SQLyog with the WINE Windows emulator ... (34917 views)
- Why are Stored Procedures not created when I import ... (34261 views)
Latest FAQs 
- SQLyog Version History (2012-01-26 08:20)
- SQLyog is a client for the MySQL server - ... (2011-11-04 04:48)
- I get error 1130 "Host is not allowed to ... (2011-11-01 05:21)
- Problems on Ubuntu 11.x (2011-10-29 13:02)
- Problems creating a functional DSN on 64 bit Windows. ... (2011-09-15 14:34)
Sticky FAQs
Using the GUI
The 'remove comment' functionality does not remove all comments.
SQLyog GUI provides an option to highlight any set of statements in the Editor and 'comment-out' those statements. And to revert back again (un-commenting) too, of course.
The purpose of this is to provide a fast way to 'exclude' one or more statements in an Editor tab from execution with 'execute all'. It simply does so by replacing
this_statement;
with
-- this_statement;
The 'remove comments' functionality only removes this type of comments and only when they start on the first position of the line
This means that all comments like
1)
# comment
2)
some_statement; -- comment here not starting at first position
3)
/* comment */
4)
/* multi-
line
comment */
are not touched. And it never was the intention to do!
If you use SQLyog as your only or primary GUI-client you can reserve the
-- style comments
for use with the SQLyog add/remove comments functionality and use the other available comment-styles for comments that should be permanent in the code.
Tags: -
Related entries:
- Welcome to the SQLyog FAQ
- SQLyog Version History
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
- Can I use SQLyog with MySQL version 5 features like Views, Stored Procedures and Triggers
- I am behind firewall or router. Can I use SQLyog to manage a remote MySQL server?
Last update: 2006-09-18 14:29
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ