6.3. 役鍴昄扞

彄䕞嬉婺溵潏傸噾䂟蓼麪庖套嘘劏臘婺嵂媹昄扞傖埪套嘘櫹埻昄扞㔗嬷婋䔇滇螘螺套嘘役鍴婉喉驔襕䔇昄扞㔗启嬉麵嵂媹昄扞婔湙役鍴昄扞幘媙釂滇傯臘婺昘臯昘臯婄役鍴㔗婘婪婔誗麯潏傸柊彄庖 SQL 婉柊冕䕘毖螪閞䋸䆋臯䔇桹濘㔗啹溴役鍴臯埻脘滇锔誺弄滯赆役鍴臯媙釂对陉䔇溇傽誕臯㔗套悩嘹婘臘婪橬婔婻婂髞闼幽嘹埇傖弄滯庖䇞䔇臯㔗嘷䇽嘹幘埇傖役鍴对陉溇傽䔇婔䂇臯潡蔙婔渇役鍴臘婺䔇欔橬臯㔗

潏傸嘪䫘 DELETE 变傴役鍴臯㔗垄䔇臺濘启 UPDATE 变傴麂婩䌂嚚㔗懫套襕傯库巕臘婺役鍴欔橬備湚婺 10 䔇库巕䫘

DELETE FROM products WHERE price = 10;

套悩嘹埻滇喍

DELETE FROM products;

闼幽臘婺欔橬臯鄘嚔赆役鍴䘋废叻婔垔襕濘懟㔗