sql
shabSELECT
SELECT column1, column2, ... FROM table_name WHERE condition;
пример
SELECT CustomerName, City FROM Customers;
DELETE
DELETE FROM table_name WHERE condition;
пример
DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';
UPDATE
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
пример
UPDATE Customers SET ContactName = 'Alfred Schmidt', City= 'Frankfurt' WHERE CustomerID = 1;
INSTERT INTO
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
пример
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');
Разные примеры
SELECT MAX(column_name) FROM table_name WHERE condition;
соединяет по общему полю:
SELECT * FROM Orders LEFT JOIN Customers
SELECT * FROM Products WHERE Price NOT BETWEEN 10 AND 20;