SQL基础指令

create database SQL1;/*创建数据库*/
show databases;/*展示数据库*/
drop database SQL1;/*删除数据库*/
use SQL1;/*使用数据库*/

/*创建表*/
create table Student(
  student_id int primary key,/*主键值*/
  `name`  varchar(10),
   major  varchar(10),
   socre int
);

describe Student;/*展示表*/
drop table Student;/*删除表*/
alter table Student add gpa decimal(3,2);/*添加表元素*/
alter table Student drop column gpa ;/*删除表元素*/

select *from Student;/*展示表格所有数据*/
select *from Student limit 3;/*展示表格前3数据*/
select `name`,`major`from Student;/*展示表格name和major属性,用反引号*/
select*from Student order by socre;/*socr属性排序从低到高*/
select*from Student order by socre desc;/*socr属性排序从高到低*/
select*from Student order by socre,student_id desc;/*如果socr属性一样则根据id排序从高到低*/
insert into Student values(1,"小红","语文",60);/*插入表格值*/
insert into Student values(2,"小白","英语",70);/*插入表格值*/
insert into Student values(3,"小张","数学",80);/*插入表格值*/
insert into Student values(4,"小蓝","语文",60);/*插入表格值*/

set sql_safe_updates=0;/*关闭预设更新模式*/
update Student/*更新表格*/
set major='语文文学'
where major="语文";/*更改语文为语文文学*/
delete from Student
where socre=80;/*删除得分等于80的*/