永无止境

mysql in() 子查询 优化in 如果里面是一个子查询是不会使用索引的比如 select  *  from user where id in( select id form user)优化select * from user u1 left join (select id from user) u2 on u1.id = u2.id这样就能使用索引

SELECT * FROM ( SELECT @r AS id, (SELECT @r := father FROM user_relainfo where id = @r) AS father FROM (SELECT @r := 455) vars, user_relainfo h WHERE @r <> 409) T1 SELECT...

直接上代码@Configurationpublic class HBaseConfig { @Primary @Bean @ConfigurationProperties(prefix="spring.datasource.druid.mybatis") public DataSource druidDataSource() { retur...

新项目重构,由于数据量太大,采用了mysql存主表和hbase存记录表的方式(使用的phoenix操作hbase,通过mybatis多数据源连接mysql和phoenix,具体实现移步https://blog.csdn.net/qq_31349087/article/details/88535387)现有一个需求,分别按老师,班级,校区的维度查询学员的实操合格率,作业达标率,目前老师,班级...