| Courses Software Training / Animation / Graphic Designing | Locality Kulathupalayam |
MySQL Server supports some extensions that you probably won't find in other SQL DBMSs. Be warned that if you use them, your code won't be portable to other SQL servers. In some cases, you can write code that includes MySQL extensions, but is still portable, by using comments of the following form:
/*! MySQL-specific code */
In this case, MySQL Server parses and executes the code within the comment as it would any other SQL statement, but other SQL servers will ignore the extensions. For example, MySQL Server recognizes theSTRAIGHT_JOIN keyword in the following statement, but other servers will not:
SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ...
If you add a version number after the “!” character, the syntax within the comment is executed only if the MySQL version is greater than or equal to the specified version number. The TEMPORARY keyword in the following comment is executed only by servers from MySQL 3.23.02 or higher.
Fu-vision Training solutions private limited
www.fuvision.com
www.fucraft.com
www.fuanimedia.com
Contact for more information: 9003206648; 9360029290
Coimbatore Address:
No: 96,Hope College bus stop,
Opp Krishna sweets, Peelamedu,
Avinashi road, Coimbatore.
Madurai Address:
Near BELL Hotel,
Rajan Complex – 3rd floor
Tamil Sangam Road,
Madurai