开发者

Difference between 'character set' and 'default character set'

开发者 https://www.devze.com 2023-03-01 01:39 出处:网络
Is there any differ开发者_如何学Cence between statements ALTER TABLE xxx DEFAULT CHARACTER SET utf8

Is there any differ开发者_如何学Cence between statements

ALTER TABLE xxx DEFAULT CHARACTER SET utf8

and

ALTER TABLE xxx CHARACTER SET utf8 ?

MySQL documentation keeps silence about functionality of DEFAULT keyword.


There is no difference. DEFAULT is an optional keyword.

See: http://dev.mysql.com/doc/refman/5.6/en/charset-table.html.

Optional keywords that don't do anything are quite common in SQL, for example INSERT INTO is the same as just INSERT. It’s a question of style whether you include optional keywords. They don't have any effect on the function of the query, but they might make it more readable.

0

精彩评论

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