1、
INSERT INTO 表名(列名列表) VALUES(值列表);
例如：INSERT INTO BOOK(bookid,name,price) VALUES('100123','oracle sql',54.70);
2、
delete from 表名 where
例如：DELETE FROM COURSES WHERE COURSE_DESIGNATER = 'Java110'
3、
update 表 set 字段1 = 值,字段2 = 值 where 字段3 = 值
4、
Select * from table where
INSERT INTO 表名(列名列表) VALUES(值列表);
例如：INSERT INTO BOOK(bookid,name,price) VALUES('100123','oracle sql',54.70);
2、
delete from 表名 where
例如：DELETE FROM COURSES WHERE COURSE_DESIGNATER = 'Java110'
3、
update 表 set 字段1 = 值,字段2 = 值 where 字段3 = 值
4、
Select * from table where
扫一扫
520
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
