1、基于可视化视图的数据操作很简单,我就不介绍了,下面是利用Sql语句进行数据操作的介绍;
另注:本文以如下数据库为例:
2、增——插入记录(insert):
(1)语法:
INSERT INTO "表格名" ("栏位1", "栏位2", ...)
VALUES ("值1", "值2", ...);
(2)示例:
insert into STUDENT (STUDENT_ID, SNAME, GENDER, BIRTHDAY)values('000003', '王五', '男', '24');
insert into STUDENT values('000004', '李五', '男', '24');
3、删——删除记录(delete)
(1)语法:
DELETE FROM "表格名"
WHERE "条件";
(2)示例:
delete from STUDENT where STUDENT_ID = '000004';
4、改——修改记录(update)
(1)语法:
UPDATE "表格名"
SET "栏位n" = [新值]
WHERE "条件";
(2)示例:
update STUDENT set GENDER = '女', BIRTHDAY = '22' where STUDENT_ID = '000003';
5、查——查询记录(Select)
(1)语法:
SELECT "栏位名" FROM "表格名";
(2)示例:
select STUDENT_ID, SNAME, BIRTHDAY from STUDENT;
(3)结果:
6、OK,以上就是基本的操作语句