INSERT, , . , VALUES ( ) :
INSERT INTO Londonstaff
SELECT *
FROM Salespeople
WHERE city = 'London';
, , city = "London" Londonstaff. , Londonstaff :
* CREATE TABLE.
* , ; , , , ( ).
, , , , .
Londonstaff , (Salespeople). , Londonstaff ( (VIEW), 20).
INSERT , , , , , .
, , Daytotals, . , Daytotals .
, , , , INSERT
INSERT INTO Daytotals (date, total)
SELECT odate, SUM (amt)
FROM Orders
GROUP BY odate;
, , Daytotals . , , , - .
DELETE. , , . , :
DELETE FROM Salespeople;
, , DROP TABLE ( 17).
, . , , . , Axelrod ,
DELETE FROM Salespeople
WHERE snum = 1003;
snum sname , , . .
, DELETE , , :
DELETE FROM Salespeople
WHERE city = 'London';
, , , . UPDATE.
UPDATE, , SET, , . , 200,
UPDATE Customers
SET rating = 200;