|
Server IP : 172.16.15.8 / Your IP : 3.145.180.152 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/zwang/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
drop table Goods;
create table Goods (Name varchar(20), Number int);
insert into Goods values ("Java I", 32);
insert into Goods values ("Calculus I", 57);
select * from Goods;
-- update
update Goods set Number=40 where Name="Java I";
update Goods set Number=60 where Name="Calculus I";
select * from Goods;