1.DELETE FROM tbl对于table不能使用别名
DELETE FROM oppo_pim_bookmark a where a.userid='liupdhc' AND a.status='D'
2.开启 MySQL 的远程登陆帐号
grant all PRIVILEGES on 数据库名.* to 用户名@'ip地址' identified by '密码';
flush PRIVILEGES;
3.Can't find any matching row in the user table
重启mysql服务即可
4.在mysql中的列定义为timestamp时,通过java的ResultSet.getTimestamp()获取值,
如果此时timestamp在写入时为'0000-00-00 00:00:00',此时就会报
"java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' "异常,解决的方案是
在数据库连接的url中添加"zeroDateTimeBehavior=convertToNull"
5.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 0 milliseconds ago
autoReconnect=true&autoReconnectForPools=true
6.alter database funambol character set utf8;
DELETE FROM oppo_pim_bookmark a where a.userid='liupdhc' AND a.status='D'
2.开启 MySQL 的远程登陆帐号
grant all PRIVILEGES on 数据库名.* to 用户名@'ip地址' identified by '密码';
flush PRIVILEGES;
3.Can't find any matching row in the user table
重启mysql服务即可
4.在mysql中的列定义为timestamp时,通过java的ResultSet.getTimestamp()获取值,
如果此时timestamp在写入时为'0000-00-00 00:00:00',此时就会报
"java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' "异常,解决的方案是
在数据库连接的url中添加"zeroDateTimeBehavior=convertToNull"
5.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 0 milliseconds ago
autoReconnect=true&autoReconnectForPools=true
6.alter database funambol character set utf8;