[ACCEPTED]-In MySQL, what does this mean? /*!40100 DEFAULT CHARACTER SET latin1 */-mysql

Accepted answer
Score: 32
  1. It's a conditional comment that can be interpreted 10 by MySQL

  2. The code 40100 means only these 9 versions of MySQL>=4.1.0 (4.01.00) will 8 interpret the conditional comment.

  3. The ! is 7 here to force MySQL to parse the code between 6 the /* ... */

  4. It sets the value of the parameter DEFAULT 5 CHARACTER = 'latin1' so that the data in 4 an SQL dump can be intepreted correctly 3 during import. It doesn't affect the database 2 structure, but merely helps the export/import 1 process to work right.

  5. http://dev.mysql.com/doc/refman/4.1/en/comments.html

More Related questions