How To Include Comments in SQL Statements

Q

How To Include Comments in SQL Statements? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

If you want to include comments in a SQL statement, you can first enter "--", then enter your comment until the end of the line. The tutorial exercise below shows you some good examples:

SELECT 'Hello world!' FROM DUAL; -- My first SQL statement! 

INSERT INTO links VALUES ('FYIcenter.com'); -- Top rated!

CREATE TABLE faq (
   id INTEGER, -- primary key
   title VARCHAR(80) -- FAQ title
);

2007-05-11, 4959👍, 0💬