drop database stuDB;
create database stuDB;
use stuDB;
drop table stu_info;
create table stu_info
(
sno int primary key auto_increment,
sname varchar(100) not null,
age int comment '年纪',
sex char(1),
scope float(10,2),
address varchar(100)
)ENGINE=InnoDB DEFAULT CHARSET=gb2312;
alter table stu_info add column
classNo varchar(10);
alter table stu_info add column
birthday date;
insert into stu_info(sname,age,sex,scope,address,birthday)
values('cc',45,'男',56.45,'重庆',now()); --或者'1993-10-29'--
update stu_info set age=20;
update stu_info set scope=80,address='秦皇岛' where sex='男';
delete from stu_info; --清除所有数据--
delete from stu_info where sex='女';
select * from stu_info;