ddl.sql
554 Bytes
#测试表
DROP TABLE IF EXISTS test;
CREATE TABLE test(
id int(4) PRIMARY KEY NOT NULL auto_increment COMMENT '产品主键',
name VARCHAR(128) NOT NULL COMMENT '名称',
age int(4) NOT NULL COMMENT '年龄'
);
INSERT INTO test(name,age) VALUES("A","1");
#mybatis测试表
DROP TABLE IF EXISTS mybatis_test;
CREATE TABLE mybatis_test(
id int(4) PRIMARY KEY NOT NULL auto_increment COMMENT '产品主键',
name VARCHAR(128) NOT NULL COMMENT '名称',
age int(4) NOT NULL COMMENT '年龄'
);
INSERT INTO mybatis_test(name,age) VALUES("C","111");