mysql的学习笔记（阶段一）

use mysql;
create table if not exists stu2
(
sid int(11),
name varchar(10),
gender varchar(10),
brith date

);
show table stu1;
show columns from stu1;
-- alter table stu2 add address varchar(10);
alter table stu2 add (address varchar(10),score int(10));
insert into stu2 values(1,"李自成","男","1000-12-12","北京",44),(2,"华佗","男","1201-12-13","三国",100);
select distinct * from stu2; #无重复记录查找
select * from stu1

mysql的学习笔记（阶段一）最先出现在Python成神之路。