MySQL Extensions and Deviations
MySQL Extensions and Deviations This section I am going to cover material relating to the extensions and deviations of MySQL, an administrator should have the basic knowledge of the following even if he is not going to be developing How MySQL extends the SQL language Data Types Indexes Stored routines, triggers and events Views Transactions MySQL does not completely follow the SQL standard (ANSI/ISO SQL:2003 standard) and has it's own extensions and deviations. The reason for the extensions is to make the system easy to use. We start with some of the rules of the SQL language which relate to the following Comments and portability Case-sensitivity Escape characters Naming limitations Quoting Time zones Character sets and collations MySQL has a clever extension that manages portability, you can use the MySQL version as part of a comment, it will only be parsed if the mysqld server is the appropriate version, otherwise it will left as a comment and