use xuexiao;

create table studentInfo(
    `name` varchar(10),
    sex char,
    age int,
    address varchar(20)
);

show tables;

-- 插入操作
-- 值需要按照字段的順序插入，如果插入的值順序和創(chuàng)建表的順序相同沟饥，則字段可以省略
insert into studentInfo(name,sex,age,address) value ("馬嘉祺",'男',18,'河南省鄭州市');
insert into studentInfo(sex,address,age,name) value ("男",'重慶市',18,'丁程鑫');
insert into studentInfo value ("宋亞軒",'男',17,'廣東省廣州市');
select * from studentInfo;

-- 修改以創(chuàng)建的表字段默認值
alter table studentInfo change sex sex char default '男';

insert into studentInfo(name,sex,age,address) value ("翠花",'女',18,'河南省鄭州市');
insert into studentInfo(sex,address,age,name) value ("女",'重慶市',8,'嚴美娜');
insert into studentInfo value ("宋人頭",'男',17,'四川省');-- 有默認值 如果省略字段添怔，則值需要寫全
select * from studentInfo;

create table studentInfo2(
    id int auto_increment primary key,
    `name` varchar (10),
    sex char,
    age int ,
    address varchar(20)
    
);

show tables;
insert into studentInfo2(id,`name`,sex,age,address) values (1,"馬嘉祺",'女',18,'河南省鄭州市');
insert into studentInfo2(`name`,sex,age,address) values ("馬嘉祺2",'女',18,'河南省鄭州市');
insert into studentInfo2(id,`name`,sex,age,address) values (3,"宋亞軒1",'女',18,'河南省鄭州市');
insert into studentInfo2(id,`name`,sex,age,address) values (2,"宋亞軒1",'女',18,'河南省鄭州市');
insert into studentInfo2(`name`,sex,age,address) values ("宋人頭",'男',17,'四川省'),
("宋你離開",'男',17,'四川省'),
("劉耀文",'男',17,'重慶市'),
("張真源",'男',17,'重慶市'),
("嚴浩翔",'男',17,'四川省');

desc studentInfo2;
select *from studentInfo2;
select *from studentInfo;


insert into studentInfo values ("宋人頭",'男',17,'四川省'),
("宋你離開",'男',17,'四川省'),
("劉耀文",'男',17,'重慶市'),
("張真源",'男',17,'重慶市'),
("嚴浩翔",'男',17,'四川省');

insert into studentInfo2 values (9,"宋人頭",'男',17,'四川省'),
(10,"宋你離開",'男',17,'四川省'),
(11,"劉耀文",'男',17,'重慶市'),
(12,"張真源",'男',17,'重慶市'),
(13,"嚴浩翔",'男',17,'四川省');

select * from studentInfo2;

-- 修改 update ... set ... where 條件
-- 修改指定的數(shù)據(jù)
update studentInfo set name="潘金蓮" where name ="翠花";
-- 沒有寫條件，則修改全部的數(shù)據(jù)
update studentInfo set name="潘金蓮";

-- 刪除 delete from table where ... 有日志留下贤旷，可以恢復(fù)
delete from studentInfo2 where name ="宋亞軒1";-- 刪除符合條件的數(shù)據(jù)
delete from studentInfo ;-- 刪除所有數(shù)據(jù)


-- 銷毀數(shù)據(jù) 不留下日志广料，速度快，無法恢復(fù)
truncate table studentInfo2;