What does DEFAULT mean in CREATE DATABASE statement in mysql?

Question

MySQL

CREATE DATABASE `abc` DEFAULT CHARACTER SET = 'utf8';

The official documentation page dev.mysql.com/doc/refman/5.5/en/create-database.html generally shows what you can install, but you can not. Nothing changes. Is it so?

Answer 1

Default sets the default encoding, if not set here, it will be taken by default from my.conf

Answer 2

So.

SHOW CREATE DATABASE `abc`;
+----------+--------------------------------------------------------------+
| Database | Create Database                                              |
+----------+--------------------------------------------------------------+
| abc      | CREATE DATABASE `abc` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+--------------------------------------------------------------+

That is, the word DEFAULT is added automatically if necessary. /*!40100 */ means that this code will be processed in mysql 4.01.00 and higher.