Spring MVC Homework2 我的建立表的语句

-----------2014-02-28 mysql 作业 脚本-----------
create database spring_test;
use spring_test;


create table if not exists users
(
id int unsigned not null primary key auto_increment comment '主键',
username varchar(32) not null default 'dada' comment '用户名',
password varchar(32) not null default 'dada' comment '密码',
age varchar(32) not null default 10 comment '年龄', 
address varchar(32) not null default 'beijing' comment '地址'
) engine=innodb default charset=utf8 comment='用户表';
----
insert into users values(null, 'lilei', md5('lilei'), 10, '北京');  
insert into users values(null, 'hanmei', md5('hanmei'), 11, '上海');
insert into users values(null, 'dandan', md5('dandan'), 11, '杭州');
insert into users values(null, 'lei', 'lei', 10, '北京');

转载于:https://www.cnblogs.com/robbychan/p/3786527.html