MySQL（1）

1. 创建表

create table student(
	stu_id      varchar(10) primary key ,
	stu_name    varchar(10) ,
	stu_sex     varchar(2),
	stu_address varchar(100),
	stu_age     int ,
	stu_date    timestamp 
)

2. 查询表的数据

select 字段列表 from 表名 [条件]
select * from student ;

3. 插入数据

insert into 表名 [(字段名1,字段名2......)]  values  (字段值1,字段值2,......);

insert into student values ('101' ,'zhangsan','男','asdfa',18, str_to_date('08.09.2008 08:09:33','%d.%m.%Y %h:%i:%s')  );
insert into student values ('102' ,'lisi','女','asdfa',20, str_to_date('08.09.2018 14:09:33','%d.%m.%Y %H:%i:%s')  );
select date_format( stu_date,'%d.%m.%Y %H:%i:%s') bir from student;
insert into student(stu_id,stu_age ,stu_name) values ('103',22,'wangwu');
（%H : 24小时制     %h：12小时制）

4. 修改数据

update  表名 set  字段名 = 新字段值  [条件]
update  student  set  stu_age = 21  where stu_name = 'zhangsan';

5. 删除数据

delete from 表名   [条件]
delete from student  where stu_name = 'zhangsan';

6. 删除表

drop table student ;