表数据操作
插入数据:
insert into 表名(字段1,字段2...) values (值1,值2...);
eg:insert into emp (empno,ename,job,mgr,hiredate,sal,comm,deptno)value(7369,'smith','clerk','7902','1980-12-17',800,null,20);
表示:
整,小数常量:用原样
字符串:'zifuchuan'
日期:'1990-7-1'
省略字段名:
insert into 表名 value(值1,值2...);
插入多条:
insert into 表名 value(值1,值2.....),(值1,值2...);
插入部分字段的值:
insert into 表名(字段1,字段2...) value (值1,值2...);
set插入:
insert into 表名 set 字段名1 = 值1, 字段名2 = 值2...;
题:
答案:
1,
2,
3,
4,
5,
例:
insert into s set sno = 201703,sname = 'ALLEN',ssex = '女',birth = '2000-1-21',mno =null ,birthplace = '山东省济宁市任城区',phone = '15505377566',score =311,deptno = 20;
insert into d set deptno = 40 ,dname = '基础部',address = '2号教学楼211';