开发者

Creating mysql table with explicit default character set, what if I don't?

开发者 https://www.devze.com 2022-12-18 06:10 出处:网络
In mysql 5.x Whats the difference if I do something like this: CREATE TABLE aTable ( idBIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,

In mysql 5.x Whats the difference if I do something like this:

CREATE TABLE aTable (
    id                       BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    aNumber          bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8开发者_StackOverflow;

with this:

CREATE TABLE aTable (
   id                       BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
   aNumber            bigint(20) DEFAULT NULL
) ENGINE=InnoDB CHARACTER SET=utf8;

Notice I am not specifying the character set as default in the first one. I couldn't find anything in the mysql docs.


The word DEFAULT is optional there - so the two are equivalent, i.e. they set the default character set for the table.

See the MySQL documentation for CREATE TABLE. Here's the relevant bit:

table_option:
    ENGINE [=] engine_name
  ... other options ...
  | [DEFAULT] CHARACTER SET [=] charset_name
  ... more options ...

You can confirm this using the SHOW CREATE TABLE command.


There are 4 levels of default settings in MySQL: server, database, table, and column. Using lower level defaults, you can override higher lever defaults.

If you alter a table that has default charset set to something other than what the database has set, the table default will override the db default.

0

精彩评论

暂无评论...
验证码 换一张
取 消