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 ... (115113 views)
- Error no. 2003: Can't connect... (51941 views)
- Error no. 1251: "Client does not support authentication..." (48020 views)
- Error no. 1045: "Connection denied..." (41222 views)
- SQLyog Version History (39818 views)
- What is HTTP-tunneling? (29193 views)
- Error No. 2005: Unknown MySQL server host... (28237 views)
- What Is SSH and SSH-tunneling? (25423 views)
- Why are Stored Procedures not created when I import ... (23362 views)
- Do I need PHP to use SQLyog with MySQL? ... (21456 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- 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)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
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