数据库增删改操作（小白）

CREATE TABLE `user`(id int(10),name varchar(20))  ( 新建表 )

INSERT into user(Id_p,Lastname,Firstname,Address,City) VALUEs("1","A","一","ff","cd")  （添加行）

UPDATE user set Id_p="2",City=2 WHERE Id_p=3 AND City=4  

DELETE FROM user WHERE Id_p=3      （删除指定）

SELECT * FROM `user` WHERE Id_p=1   （查找）

SELECT Address,City FROM `user` WHERE Id_p=1（查找）

SELECT Address as 新建,City as 城市 FROM `user` WHERE Id_p=1（查找）

SELECT DISTINCT Lastname as 姓名 FROM `user`  (消除重复，一次显示)

SELECT DISTINCT Lastname,City FROM `user` 

SELECT ename as 姓名,sal>2000 as 是否 FROM emp

SELECT ename as 姓名,sal!=1250 as 是否 FROM emp

SELECT from emp where sal>800

SELECT *FROM emp WHERE job like "%M%" (查询emp当中有M的 %表示一个或多个字符)

SELECT *FROM emp WHERE job like "M%"  （查询emp中首位是M的）

SELECT *FROM emp WHERE job like "_A%" （查询emp中第二位是A的，_表示一个字符）

SELECT *FROM emp WHERE job like "__A_%" (查询第三位是A后边至少有一位的)

SELECT *FROM emp WHERE mgr=7698 or mgr=7839(or的查询用法)