提示:用ctrl+F快速查找相关指令哦
create database test_sql;
sp_renamedb 'test_sql','exam_sql';
drop database test_sql;
use test_sql;
create table student(
sid int NOT NULL PRIMARY KEY,
sname VARCHAR(20) ,
sage INT not NULL CHECK (sage BETWEEN 1 and 100),
semail VARCHAR(50) CHECK (semail LIKE '_%@._%')UNIQUE
);
DROP TABLE student;
DELETE FROM employees;
TRUNCATE TABLE employees;
ALTER TABLE student add sphone VARCHAR(16);
ALTER TABLE student ADD PRIMARY KEY(sid);
ALTER TABLE student DROP primary key(sid);
create UNIQUE INDEX emailIndex on student (semail);
drop INDEX emailIndex on student;
CREATE VIEW studentView as SELECT sid from student;
DROP VIEW studentView;
insert into student(sid,sname,sage,semail,sphone) VALUES (3,'test',17,'3@.com','15239958942');
update student SET sphone ='15239958914' where sage BETWEEN 10 and 20;
select * from student;
select * from student where sid = 2;
select * from student where semail like '%@%';
select * from student ORDER BY sid DESC;
select COUNT(DISTINCT sage) as sagecount from student ;
select SUM(sage) as sagesum from student;
select AVG(sage) as sageavg from student;
select MAX(sage) as sagemax from student;
select MIN(sage) as sagemin from student;
DELETE FROM student where sid = 2;
select semail from student UNION select semail from users;
select semail from student EXCEPT select semail from users;
select semail from student INTERSECT select semail from users;
select student.semail from student LEFT JOIN users ON student.semail = users.semail;
select student.semail from student RIGHT JOIN users ON student.semail = users.semail;
select student.semail from student FULL JOIN users ON student.semail = users.semail;
select sage,sum(sage) as '年龄和' from student GROUP BY sage;