hanjungua8144的博客

DELETEFROM bd_countryWHERE id IN ( SELECT id FROM bd_country WHERE statecode IS NULL AND citycode IS NULL AND nameCN IS NULL )然后出现了  [Err] 1093 - You can't specify target table 'bd_country'...

SELECT * FROM tb_table WHERE sample_code IN(SELECT sample_code FROM tb_table GROUP BY sample_code HAVING COUNT(sample_code) > 1);

单数据路径配置 <bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource2" /> <property name="m

1.下载安装包 到mysql官网下载mysql编译好的二进制安装包，在下载页面Select Platform:选项选择linux-generic，然后把页面拉到底部，64位系统下载Linux - Generic (glibc 2.5) (x86, 64-bit)，32位系统下载Linux - Generic (glibc 2.5) (x86, 32-bit) 2 卸载老版本MySQL ...