mysql常见问题集（1）-持续更新

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;