![]() The reason is better explained with an example: CREATE PROCEDURE p () BEGIN SELECT * FROM t1 SELECT * FROM t2 END This can be done in any situation, but it is particularly useful when creating stored routines or using BEGIN NOT ATOMIC. However, MariaDB also has some situations where you want to use a but you don't want the mariadb command-line client to send the query yet. It is required for certain common table expressions, for example.īut the same doesn't apply to MariaDB. It is rarely necessary to use in SQL Server. The query terminator is a semicolon ( ) and it tells SQL Server where a query ends. ![]() It tells Microsoft clients to send the text we typed to SQL Server. The batch terminator is the go command.SQL Server uses two different terminators: Here we discuss some differences between MariaDB and SQL Server syntax that may affect any user, as well as some hints to make queries compatible with a reasonable amount of work. But because MariaDB also supports specific syntax not supported by MySQL, it added the /*M!. */ syntax is supported by both MariaDB and MySQL. At that time, executable comments were already supported by MySQL. Executed by MariaDB starting from version 10.0.5:ĭELETE FROM user WHERE id = 100 /*!M100005 RETURNING email */ Īs explained in the Understanding MariaDB Architecture page, MariaDB was initially forked from MySQL.SELECT * FROM tab /*! FORCE INDEX (idx_a) */ WHERE a = 1 OR b = 2 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |