qq_36375934的博客

分页查询，同时返回总记录数时使用如下查询：select SQL_CALC_FOUND_ROWS * from user limit 0,10;SELECT FOUND_ROWS() as count;出现报错信息，且报错信息是第二个语句。### The error may involve defaultParameterMap### The error occurred while setting parameterscom.mysql.jdbc.exceptions.jdbc4.

1、查看mysql数据的存放位置mysql> show global variables like "%datadir%";  或 select @@datadir;2、修改mysql数据存放位置一.首先把mysql的服务先停掉。二.更改MySQL配置文件My.ini中的数据库存储主路径打开MySQL默认的安装文件夹C:\Program Files\MySQL\MySQL S...

原文地址：http://nkcoder.github.io/blog/20140712/mysql-reconnect-packet-lost/1.1 错误信息：Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the...

1、创建.batrem *******Start Backup***********@echo offset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"set fileName1="integrated_%Ymd%"set fileName2="integrated_test_%Ymd%"del \\192.168.1.10\mysql_backu...