MySQL问题集.docVIP

MySQL问题小结 在Mysql6.0中执行:create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) type=InnoDB;出现错误:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near type=InnoDB at line 1,把type=InnoDB去掉,可以成功建表，但有时有些未知错误.把type=InnoDB改成ENGINE=InnoDB,也可以成功建表,程序运行正常. Hibernate中方言引用要和建表时一致 org.hibernate.dialect.MySQLInnoDBDialect 2. MySQL默认字符编码是latin1 mysql show variables like character%; +--------------------------+--------------------------+ | Variable_name | Value | +--------------------------+--------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | D:\MySQL\share\charsets\ | +--------------------------+--------------------------+ 创建数据表并插入数据 mysql use test; mysql create table messages ( - id int(4) unsigned auto_increment primary key, - message varchar(50) not null - ) engine=myisam default charset=utf8; mysql insert into messages (message) values (测试MySQL中文显示); mysql select * from messages; +----+-------------------+ | id | message | +----+-------------------+ | 1 | 测试MySQL中文显示 | +----+-------------------+ 编写程序（Java） import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class JDBCTest { public static void main(String[] args) { String driver = com.mysql.jdbc.Driver; String url = jdbc:mysql://localhost:3306/test; String user = root;