mysql基础班进阶二

一、单表增删改查基础篇

1.ALTER TABLE emp add money DECIMAL;   //修改表的结构
   ALTER TABLE emp DROP money;

2. select *[字段名列表] from [表名] where 过滤条件1 and 过滤条件2   //多个条件查询

 select * from student where sex='男';

3. insert into tb(字段列表) value (?,?,?)  //添加一个字段

    INSERT into emp(empno,sal) VALUES(200,2);

4.delete from tb where 过滤条件   //删除一个字段

  DELETE  FROM emp WHERE sal='2';

5.update tb set col=? where 过滤条件 //修改一个内容

 UPDATE emp set sal='80' where deptno='20';

二、基础查询补充篇

1.-排序 order by

  SELECT * from tb order by 字段名;//默认升值

  SELECT * FROM emp ORDER BY sal;//升序

  SELECT * FROM emp ORDER BY sal DESC;//降序

2.-随机排序 RAND()

   SELECT * FROM emp ORDER BY RAND() ;

3.-分页limit

SELECT * FROM emp LIMIT 2,4;