Description\n-----------\n\nThere are three supported comment styles in MariaDB:\n\n1. From a hash sign (#) to the end of a line:\n\n``sql\nSELECT  FROM users; \n\nThis is a comment\n\n`\n\n1. From a double dash (--) to the end of a line. The space after the two dashes is required (as in MySQL).\n\n`sql\nSELECT  FROM users; -- This is a comment\n`\n\n1. C style comments from an opening '/' to a closing '/'. Comments of this form can span multiple lines:\n\n`sql\nSELECT  FROM users; / This is a\nmulti-line\ncomment /\n`\n\nNested comments are possible in some situations, but they are not supported or recommended.\n\nExecutable Comments\n\nAs an aid to portability between different databases, MariaDB supports executable comments. These special comments allow you to embed SQL code which will not execute when run on other databases, but will execute when run on MariaDB.\n\nMariaDB supports both MySQL's executable comment format, and a slightly modified version specific to MariaDB. This way, if you have SQL code that works on MySQL and MariaDB, but not other databases, you can wrap it in a MySQL executable comment, and if you have code that specifically takes advantage of features only available in MariaDB you can use the MariaDB specific format to\\\nhide the code from MySQL.\n\nExecutable Comment Syntax\n\nMySQL and MariaDB executable comment syntax:\n\n`sql\n/! MySQL or MariaDB-specific code /\n`\n\nCode that should be executed only starting from a specific MySQL or MariaDB version:\n\n`sql\n/!##### MySQL or MariaDB-specific code /\n`\n\nThe numbers, represented by '######' in the syntax examples above specify the specific the minimum versions of MySQL and MariaDB that should execute the comment. The first number is the major version, the second 2 numbers are the minor version and the last 2 is the patch level.\n\nFor example, if you want to embed some code that should only execute on MySQL or MariaDB starting from 5.1.0, you would do the following:\n\n`sql\n/!50100 MySQL and MariaDB 5.1.0 (and above) code goes here. /\n`\n\nMariaDB-only executable comment syntax (starting from MariaDB 5.3.1):\n\n`sql\n/M! MariaDB-specific code /\n/M!###### MariaDB-specific code /\n`\n\nMariaDB ignores MySQL-style executable comments that have a version number in the range 50700..99999. This is needed to skip features introduced in MySQL-5.7 that are not ported to MariaDB 10.x yet.\n\n`sql\n/!50701 MariaDB-10.x ignores MySQL-5.7 specific code /\n`\n\nNote: comments which have a version number in the range 50700..99999 that use MariaDB-style executable comment syntax are still executed.\n\n`sql\n/M!50701 MariaDB-10.x does not ignore this /\n``\n\nStatement delimiters cannot be used within executable comments.\n\nExamples\n--------\n\nSELECT 2 / +1 /;\nSELECT 1 /! +1 /;\nSELECT 1 /!50101 +1 /;\nSELECT 2 /M! +1 /;\nSELECT 2 /M!50301 +1 */;\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/comment-syntax