post item
2018年12月18日 14:22:55

Mysql 杂项

Galgame_News


https://overtrue.me/articles/2014/10/mysql-explain.html    查询 Explain


https://overtrue.me/articles/2014/10/mysql-performance-optimization-summary.html    mysql 优化


https://www.mycli.net/    mysql->Aoto 

http://www.mamicode.com/info-detail-1974037.html

http://www.zsythink.net/archives/1450

=====

<iframe src="http://www.staggeringbeauty.com/" style="border: 1px inset #ddd;width: 32%;margin-left: 25%;" width="600" height="598"></iframe>


https://blog.caoyue.me/post/support-emoji-in-mysql
CREATE TABLE IF NOT EXISTS table_name (
    ...
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
--
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR   Variable_name LIKE 'collation%';

CREATE TABLE `test_varchar` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`city_id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
`realname` VARCHAR(10) NOT NULL COLLATE utf8mb4_unicode_ci DEFAULT '',
`name` VARCHAR(10) NOT NULL DEFAULT '',
`createtime` TIMESTAMP NOT NULL DEFAULT now(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB;

INSERT test_varchar (city_id,realname,name)
VALUE 
(23, '我是谁我是谁我是谁我', '我是谁我是谁我是谁我');







 发布者!!

Comments

Leave a comment

Loading