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

8 comments:

  1. A IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.



    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete