Comments in MySQL or MariaDB - MySQL Developer Tutorial

Comments in MySQL or MariaDB


If you need to comment out only single line, then you can use -- or #. If you are using -- then after -- use the space.

Example:



-- This is comment
Select * from customer
# Select * from employee


If you need to comment out multiple lines then you can use /* multiple line comments */.


/* Use customer table 
to get information related to 
customers

*/



Executable Comments : 

MySQL provides executable comments , so the code will run on MySQL database but not on other databases systems.


/*! Your Code here */


This will run on MySQL database but not on other database systems.


How to use Comments in MySQL  or Comments in MairaDB - MySQL Developer Tutorial