INSERT INTO

ADD INTO

UPDATE ... SET ...

WHERE ...

ADD INTO employees VALUES (101, 'John Doe', 'Marketing');

INSERT employees (101, 'John Doe', 'Marketing');

INSERT INTO employees SET id = 101, name = 'John Doe', department = 'Marketing';

INSERT INTO employees (employee_id, name, department) VALUES (101, 'John Doe', 'Marketing');

Descript

SET

P_Code

Store

FETCH ...... FROM customers;

SELECT ALL customers;

GET DATA customers;

SELECT ...... FROM customers;

เป็นค่าของ Fname ใน Employees ที่มี EmployeeID = "2010"

เป็นค่าของ Fname ใน EmployeeID

เป็นค่าของ Employees ที่มีค่าเท่ากับ "2010"

จะได้ค่าของ Attribute Fname ทั้งหมดใน Table Employees

Relational Algebra

Tuple Relational calculus

Relational Algebra และ Tuple Relational calculus

ไม่มีข้อถูก

INTO

WHERE

FROM

UPDATE

UPDATE products MODIFY price = 25.99 WHERE product_id = 101

CHANGE products SET price = 25.99 WHERE product_id = 101

MODIFY products SET price = 25.99 WHERE product_id = 101

UPDATE products SET price = 25.99 WHERE product_id = 101

REMOVE FROM orders WHERE status = 'Cancelled';

DELETE ...... FROM orders WHERE status = 'Cancelled';

DELETE FROM orders WHERE status = 'Cancelled';

DROP FROM orders IF status = 'Cancelled';