V
V
Vanes Ri_Lax2016-04-11 12:59:38
MySQL
Vanes Ri_Lax, 2016-04-11 12:59:38

What does this SQL query mean?

Hello,
I have this line of SQL code:

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `_mo` /*!40100 DEFAULT CHARACTER SET latin1 */;

I'm interested in the 2 parts between the characters /* */
What does that mean? More specifically, what do the numbers with the "!" sign mean:
!32312
!40100 Many
thanks in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2016-04-11
@vanesxl

/*!32312 */ - text inside comment is used if mysql version is higher or equal to specified
For MySQL below 3.23.12 the full line will be
For versions from 3.23.12 to 4.0.xx:
For 4.1.0 and higher

CREATE DATABASE IF NOT EXISTS `_mo` DEFAULT CHARACTER SET latin1;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question