案例1:插入数据
INSERT INTO "WATERBOSSFACTORY"."TBL_STUDENTS"("STU_NUM", "STU_NAME", "STU_SEX", "STU_AGE", "STU_TEL", "STU_CID") VALUES ('2022000001', '赵云', '男 ', '22', '17896523785', '001');
insert into table_name(column1,column2) select column1,column2 from other_table;
// 创建表时直接插入数据
CREATE TABLE tbl_test AS SELECT STU_NUM,STU_AGE,STU_SEX FROM TBL_STUDENTS;
注:
(1)小括号中指定需要添加数据的列名,可以一个到多个,如果是所有列都添加数据时,可以省略,建议不省略
(2)values中给出的数据需要和列名一致
案例2:修改数据
UPDATE "TBL_STUDENTS" SET "STU_NUM" = '2022000003', "STU_NAME" = '赵云', "STU_SEX" = '男 ', "STU_AGE" = '22', "STU_TEL" = '17896523785', "STU_CID" = '001' WHERE "