mysql
冬之松柏
编程是一门艺术,赚钱是一种思维!
展开
-
如何保证mysql查询按in的顺序,thinkphp
1.使用in查询如何保证顺序普通查询:order(field(id,3,4,2,1,6,13))tp5:引入use think\db\Expression;$exp = new Expression('field(id,'.$detail['ids'].')'); //用于排序$list = db('web_content',[],false)->order($exp)->select();...原创 2020-10-15 16:52:21 · 546 阅读 · 0 评论 -
mysql入库字段编码导致报错 Incorrect string value: ‘\xF0\x9F\x91\xBD\xF0\x9F...‘ for column ‘content‘
编码不对,设置即可数据库编码ALTER DATABASE `库名` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;表编码ALTER TABLE 表名 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;字段编码ALTER TABLE 表名 MODIFY COLUMN 字段名LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ...原创 2020-09-19 23:21:52 · 1583 阅读 · 0 评论 -
/usr/local/mysql/var/localhost.localdomain.pid
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/var/localhost.localdomain.pid).1. 99%权限问题我的安装在 /usr/localcd /usr/local数据库目录 chown -R mysql:mysql mysql...原创 2019-06-24 18:05:50 · 3766 阅读 · 3 评论