MySQL Comments

In MySQL, comments are used to add explanations or notes in SQL code. They are ignored by the database during execution. Comments are useful for documenting queries or temporarily disabling code.

🔹 Types of Comments in MySQL

Single-Line Comment Using --

Everything after -- on the same line is ignored.
Must have a space after --.

Single-Line Comment Using #

Everything after # on the same line is ignored.

Multi-Line Comment Using /* */

Can span multiple lines.
Everything between /* and */ is ignored.

🔹 Examples in SQL

-- Select all students
SELECT * FROM students;

# Select students with marks > 80
SELECT * FROM students WHERE marks > 80;

-- Select all students

SELECT * FROM students;

# Select students with marks > 80

SELECT * FROM students WHERE marks > 80;

/*
This query selects students from IT and HR departments
who scored more than 80 marks
*/
SELECT *
FROM students
WHERE marks > 80 AND dept IN ('IT', 'HR');

This query selects students from IT and HR departments

who scored more than 80 marks

SELECT *

FROM students

WHERE marks > 80 AND dept IN ('IT', 'HR');

🔹 Key Points

Comments do not affect query execution.
Useful for documentation, debugging, or temporary code removal.
Supports single-line (-- or #) and multi-line (/* */) comments.

MySQL Comments

MySQL Comments

🔹 Types of Comments in MySQL

🔹 Examples in SQL

🔹 Key Points

You may also like...

Leave a Reply Cancel reply

MySQL Comments

MySQL Comments

🔹 Types of Comments in MySQL

🔹 Examples in SQL

🔹 Key Points

You may also like...

MySQL DROP DATABASE Statement

MySQL HAVING Clause

MySQL Self Join

Leave a Reply Cancel reply