In this MariaDB tutorial we'll walk you through one of the most unusual SQL interview questions and answers - how do you write SQL comments in a MySQL or MariaDB Server-specific way? Well, let us tell you - it's more simple than you would've thought!

/*! A MySQL Server or MariaDB Server Specific Comment */
/*!50500 A Comment for MySQL Server & MariaDB Server 5.5.0+! */

"/*!" and "*/" denotes a MySQL Server and MariaDB Server-specific SQL comments.

"/*!#####" mark the MySQL Server and MariaDB Server versions that the comment is SQL specific to.

"/*M!" is a MariaDB-specific comment.

"/*M!#####" marks the MariaDB Server version that the SQL comment is specific to.

/*M! MariaDB Comment */

/*M!###### MariaDB Server Comment ("###### - MariaDB Server Version) */

Numbers from 50700 to 99999 in the SQL comment blocks are ignored by MariaDB Server 10, unless these SQL comments have a MariaDB Server-specific SQL comment syntax.

Enjoy this sql tutorial and tell us in the comment section below - do you need another sql tutorial for beginners targeting mariadb installation? Have you watched our mariadb maxscale video already? If not, make sure to watch our in-depth sql interview questions and answers tutorials!

Music:
Venice Beach by TVARI: [ Ссылка ]
Creative Commons — Attribution-ShareAlike 3.0 Unported CC BY-SA 3.0
Free Download / Stream: [ Ссылка ]
Music promoted by Audio Library: [ Ссылка ]

#shorts #database #web #webdevelopment #developer #mysql #sql #mariadb

свернуть