一、增 在某表添加一行:

  • 只插入行中某些列:
    insert into class
    <name,gender,salary>
    value
    <'枫耀',‘男’,8765.43>;
  • 插入行中所有列:
    insert into class
    values
    <'枫耀',‘男’,'22',8765.43>;
  • 同时插入多行:
    insert into class
    <name ,gender ,salary>
    values
    <'刘备',‘皇室成员’,15.28>
    <‘孙策’,‘江东集团’,‘56.34’>
    <‘曹操’,‘宦官后裔’,‘10.12’>

二、改 更新某表的某列

  • update class
    set gender=‘男’ ,fanbu='212'
    where id =6;

三、删 删除某表的某行数据

  • delete from class
    where salary>8800;
  • delete from class
    where salary>8000 and gender='女';

四、查 查找哪个表的哪些列

  • select name,company,salary
    from class
    where id=6;
  • 暴力查找class表的全部:
    select * from class;
  • select * from class
    where id>3;