drop database `mydata`;
create database `mydata` default character set gbk;
use `mydata`;
create table `t_user`
(
`user_id` int not null auto_increment,
`name` varchar(8) not null default '',
`sex` char(1) not null default '',
`birthday` year(4) not null default '1901',
`address` varchar(7) not null default '',
`idnumber` char(18) not null default '',
`wage` decimal(10,2) not null default '',
`lastupdatetime` TIMESTAMP,
`updatetime` datetime not null default '',
`fff` float not null default 0.0,
primary key(`user_id`)
);
insert into t_user (姓名) values ('张三');
insert into t_user (姓名, 性别) values ('李四','男');
insert into t_user (姓名, 性别, 出生) values ('王五', '男', '1980');
insert into t_user (姓名, 性别, 出生, 住址) values ('刘六', '男', '1980', '东城区234号');
insert into t_user values (null, '七七', '女', '1980', '东城区234号', '110101198001010010');
insert into t_user values (null, '七七', '女', '1980', '东城区234号', '110101198001010010');
select * from t_user;
mysql
最新推荐文章于 2024-06-22 23:06:57 发布