严重: Servlet.service() for servlet action threw exception java.sql.SQLException: Incorrect string value: ‘\xE6\x9E\x81\xE5\x9C\xB0…’ for column ‘Modify_UserName’ at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1356)
Posts Tagged ‘mysql’
Java开发过程中的错误问题解决
Wednesday, March 24th, 2010MySQL Cluster 7.1.2 beta
Tuesday, March 16th, 2010MySQL Cluster 是 MySQL 适合于分布式计算环境的高实用、高冗余版本。它采用了NDB Cluster 存储引擎，允许在1个 Cluster 中运行多个MySQL服务器。
下载地址：http://dev.mysql.com/downloads/cluster/7.1.html
数据库导入出错:Got a packet bigger than ‘max_allowed_packet’ bytes
Tuesday, March 2nd, 2010安装mysql后,进行数据库导入时报错如下: [Err] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
是什么原因呢? 主要是导入的数据库大小超过了系统的限制.
解决办法:
批量替换WP文章中的字符串
Wednesday, December 30th, 2009我们先来看一下mysql 中的replace 命令:
replace(field, oldcontent,newcontent)
把field字段中出现oldcontent的全部替换为newcontent
Linux下 清除mysql 二进制文件
Friday, December 25th, 2009如何删除mysql-bin.0000X 日志文件呢?
红色表示输入的命令.
[root@jiucool var]# /usr/local/mysql/bin/mysql -u root -p Enter password: (输入密码) Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 264001 Server version: 5.1.35-log Source distribution
