首先复习创建学生表Students。

@H_403_2@---注意表名大小写问题 CREATE TABLE public."Students"( "StudentID" INTEGER PRIMARY KEY,"StudentName" TEXT NOT NULL,"StudentBirthday" DATE,"StudentAddress" VARCHAR(50),"StudentSalary" REAL );

先在表内插入2条数据。

@H_403_2@INSERT INTO public."Students"("StudentID","StudentName","StudentBirthday","StudentAddress","StudentSalary") VALUES ('1','贾明','1988-18-18','江苏省南京市鼓楼区','200')， ('2','贾宝玉','1988-9-9','300'),('3','甄宝玉','1988-8-8','200');

更新StudentID=2行StudentBirthday=1988-9-9数据。

@H_403_2@UPDATE public."Students" SET "StudentBirthday"='1988-9-9' WHERE "StudentID"=2;

再次练习插入一次修改多个值。

@H_403_2@UPDATE public."Students" SET "StudentBirthday"='1988-8-8',"StudentSalary"=300 WHERE "StudentID"=1;

温馨提示：本文代码和截图数据可能会存在不一致情况，请以代码为准。