weixin_43606738的博客

<!--单词选项，嵌套--> <resultMap id="wordAndOption" type="org.springblade.english.vo.WordAndOptionVO"> <result column="id" property="id"/> <result column="en_text" property="enText"/> <result column="ch_text"

本文转载于https://blog.youkuaiyun.com/smartbetter/article/details/100160069

sql分页及in字段优化分页优化先分页查询id 或者查询一个有索引的字段 再联查出所需要的字段SELECT a.* FROM USER aINNER JOIN(SELECT id FROM USER WHERE age = 10 LIMIT 100000,10) bON a.id = b.id;或者深度分页 这样有一个弊端就是插入数据后不可物理删除select * ...

windows安装mysql解压mysql5.7.26.zip在解压目录下添加my.ini文件，内容如下[client]port=3306default-character-set=utf8[mysqld]#设置mysql的安装目录basedir=D:/mysql/mysql-5.7.26-winx64#设置mysql的数据目录datadir=D:/mysql/mysql-5...