MySQL
关注
分享
扫一扫
&不羁之风&
If you wish to succeed, you should use persistence as your good friend, experience as your reference, prudence as your brother and hope as your sentry.
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
mysql月份比較是否相等
SELECT date_format(motor_arrange.arrange_date,’%Y-%m’) FROM motor LEFT JOIN motor_arrange ON motor_arrange.motor_id = motor.motor_id LEFT JOIN motor_type ON motor.motor_type_id = motor_type.motor_type_id LEFT JOIN car_stype ON motor_type.car_stype_id = car原创 2020-08-27 10:26:42 · 1731 阅读 · 0 评论 -
更改mysql数据库默认的字符集（mysql 存储 emoji表情）
UTF-8编码有可能是两个、三个、四个字节。Emoji表情是4个字节，而Mysql的utf8编码最多3个字节，所以数据插不进去。 1、更改数据库默认字符集的方法： ALTER DATABASE db_name CHARACTERSET= utf8mb4 COLLATE = utf8mb4_general_ci; eg: ALTER DATABASE daote CHARACTERSET= utf...原创 2020-04-14 15:39:13 · 255 阅读 · 0 评论