درس 5 من 9
UPDATE و DELETE
UPDATE يغير بيانات موجودة. DELETE يحذف بيانات. استخدم دائماً WHERE معهما، وإلا قد تؤثر على كل الصفوف.
SQL
-- Update a specific row
UPDATE users
SET age = 26, country = 'Denmark'
WHERE id = 1;
-- Delete a specific row
DELETE FROM users WHERE id = 5;
-- DANGER: This deletes ALL rows!
-- DELETE FROM users;