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 ... (128705 views)
- Error no. 2003: Can't connect... (58523 views)
- Error no. 1251: "Client does not support authentication..." (50542 views)
- Error no. 1045: "Connection denied..." (46251 views)
- SQLyog Version History (45078 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)
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 Webyog 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