sql基础-代码示例

前言

使用的是mysql数据库进行测试，全部是关于sql最基础的语法。

数据库如图

1、查询（最为复杂）

-- SELECT * FROM course; -- 查询所有
select cno,cname,SCORE FROM course;-- 查询某一列
select distinct cname,score from course; -- DISTINCT 去重复，去掉结果中相同的行 
SELECT * FROM course WHERE cname = "语文";     -- WHERE 子句 （条件）WHERE column_name operator value;
																							-- = > < >= ,<=, !=,<>
																							--  AND 与 OR 与not  优先级 not  》  and     》  or
SELECT * from course WHERE CNAME in ("语文","数学");							-- 判断为空 is null， between and  ，in ,LIKE(%==任意多个字符 _==任意一个字符）)
 -- ORDER BY
select cno,cname FROM course ORDER BY cname ASC;-- cno,score  ASC|DESC;
select cno,cname FROM course ORDER BY cno,cname asc;

2、插入

-- 2 插入INSERT INTO table_name (column1,column2,column3,...)    
-- VALUES (value1,value2,value3,...); 或者默认为全部字段
 INSERT INTO course VALUES(6,"新西兰语",4);

3、 修改

-- 3 修改  
-- 		UPDATE Websites 
-- 		SET alexa='5000', country='USA' 
-- 		WHERE name='菜鸟教程';
 UPDATE course set CNAME ="修改语言",score=99 where cno=1;
-- 

4、删除

-- 4 删除
delete from course where cno = 1;