SQL > ???? > Update

???? ???? ????? ??? ????. ??? UPDATE ?????? ???? ???. . ? ?????? ???:

UPDATE "???"
SET "?? 1" = [???]
WHERE "??";

? ??? ?? ?? ???? ?? ??? ?? ??? ????. ?? ???? ??? ?? ??? ???:

Store_Information ??
Store_NameSalesTxn_Date
Los Angeles150005-Jan-1999
San Diego25007-Jan-1999
Los Angeles30008-Jan-1999
Boston70008-Jan-1999

??? Los Angeles ?? 01/08/1999 ? ???? ?? $500??, ???? ??? $300? ???? ?? ???? ??? ??? ??SQL? ???? ? ???? ?????.:

UPDATE Store_Information
SET Sales = 500
WHERE Store_Name = "Los Angeles"
AND Txn_Date = "Jan-08-1999";

?? ??? ??? ?????:

Store_Information ??
Store_NameSalesTxn_Date
Los Angeles150005-Jan-1999
San Diego25007-Jan-1999
Los Angeles50008-Jan-1999
Boston70008-Jan-1999

? ??? ??? ? ??? WHERE ??? ??? ?????. ?? ???? ???? ??? ???? ??? ???? ????? ?? ???????.

??? ??? ???? ??? ???? ????. ??? ??? ????:

UPDATE "??"
SET "?? 1" = [?? 1], "?? 2" = [?? 2]
WHERE "??";

SQL DELETE FROM >>
?


Copyright © 2021   1keydata.com   All Rights Reserved