mysql
关注
分享
扫一扫
Java学习提升
专注于Java领域技术分享，Java知识体系学习、分享面试经验，让我们结伴而行，共同成长
展开
-
mysql 错误代码:1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,....
错误代码： 1267Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='解决方法：select * from user where mobile = in_mobileCOLLATE utf8_unicode_ci;#或者select ...原创 2018-05-02 09:20:33 · 23599 阅读 · 2 评论 -
MySQL删除重复数据行(只保留一条)
delimiter $$CREATE TABLE devices_all ( device_all_id int(11) NOT NULL AUTO_INCREMENT,device_id varchar(512) DEFAULT NULL, device_token varchar(512) DEFAULT NULL,client_agent varchar(512) DEFAULT NULL,...原创 2018-07-05 14:35:41 · 2719 阅读 · 0 评论