As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet.
Comments can be written in the following three formats:
- Single line comments.
- Multi line comments
- In line comments
Single line comments: Comments starting and ending in a single line are considered as single line comments.
Line starting with ‘–‘ is a comment and will not be executed.
-- single line comment -- another comment SELECT * FROM Customers;
Multi line comments: Comments starting in one line and ending in different line are considered as multi line comments. Line starting with ‘/*’ is considered as starting point of comment and are terminated when ‘*/’ is encountered.
/* multi line comment another comment */ SELECT * FROM Customers;
In line comments: In line comments are an extension of multi line comments, comments can be stated in between the statements and are enclosed in between ‘/*’ and ‘*/’.
SELECT * FROM /* Customers; */
Multi line comment -> /* SELECT * FROM Students; SELECT * FROM STUDENT_DETAILS; SELECT * FROM Orders; */ SELECT * FROM Articles; In line comment -> SELECT * FROM Students; SELECT * FROM /* STUDENT_DETAILS; SELECT * FROM Orders; SELECT * FROM */ Articles;
This article is contributed by Pratik Agarwal. If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.
- Data Visualization Using Chartjs and Django
- Must Do Coding Questions for Companies like Amazon, Microsoft, Adobe, ...
- Expand on command in Cassandra
- Rabin Cryptosystem with Implementation
- Introduction to Project Lombok in Java and How to get started?
- Simplified International Data Encryption Algorithm (IDEA)
- Bulk Reading in Cassandra
- Data Mining: Data Attributes and Quality
- Arranging clustering column in descending order in Cassandra
- Snitches in Cassandra
- Traditional Data Mining Life Cycle (Crisp Methodology)
- Data Mining: Data Warehouse Process
- Tasks and Functionalities of Data Mining
- Benefits of Content-Addressed Storage
Improved By : Rajendrarajput