简单的学习笔记

SELECT 语句：SELECT ID FROM STU;

UPDATE语句：UPDATE STU SET ID=1 WHERE NAME = 'SSUN';

DELETE语句：DELETE FROM STU WHERE ID=1;

INSERT语句：INSERT INTO STU (ID,NAME) VALUES(2,'SSUN125');

删除表：DROP TABLE STU;

新建表(加主键和外键)：CREATE TABLE STU (
ID NUMBER(10) PRIMARY KEY,
NAME VARCHAR2(20),
CLASSID NUMBER(10) REFERENCES CLASS(ID)
);