INSERT
INTO (_, , )
VALUES (1, '', '');
INSERT
INTO (_, , )
VALUES (2, '', '');
INSERT
INTO (_, , )
VALUES (3, '', ' ');
, .
INSERT
INTO
VALUES (4, '', '');
INSERT
INTO
VALUES (5, '', '');
- , CREATE ( ALTER). "SELECT *", SQL. , , SQL, . . SQL, , , , , .
.
- SELECT, UPDATE, DELETE INSERT. ( !) , , SELECT. , SELECT, . , SELECT . , , , , .
, .
, . WHERE UPDATE DELETE , FROM UPDATE DELETE. INSERT FROM , INSERT. , , , , .
DELETE
FROM
WHERE <
(SELECT AVG ()
FROM );
:
SELECT AVG ()
FROM ;
SQL. .
Structured Query Language ( ) IBM 1970- . 1986 SQL ANSI.
SQL - . . SQL : DDL (Data Definition Language - ) DML (Data Manipulation Language - ). DDL , , DML - , , , , .
|
|
DML, , DDL, SQL.
DDL
CREATE - , .
DROP - .
ALTER - .
DML
SELECT - , . SELECT :
SELECT _1 FROM _ [WHERE ORDER BY _2 [ASC | DESC]]
, , , , .
"name" "phone" "friends":
SELECT name, phone FROM friends
, , (*):
SELECT * FROM friends
, DISTINCT:
SELECT DISTINCT name FROM friends
, WHERE. , "friends" " ":
SELECT * FROM friends WHERE name = ' '
, 293-89-13:
SELECT * FROM friends WHERE phone = 293-89-13'
, , . LIKE. LIKE :
* - ;
_ - ;
[] - ;
, "name" "", :
SELECT * FROM friends WHERE name LIKE '**'
, , ORDER BY. . ASC DESC . ASC - , DESC - .
, "name" :
SELECT * FROM friends ORDER BY name
, ASC , .
INSERT - . :
INSERT INTO _ VALUES (_)
, , :
INSERT INTO friends VALUES (' ', '495-09-81')
|
|
friends .
UPDATE - WHERE. UPDATE :
UPDATE _ SET _ = [WHERE ]
WHERE, . , :
UPDATE friends SET phone = '255-55-55' WHERE name = ' '
DELETE - , . UPDATE, DELETE WHERE, , . DELETE :
DELETE FROM _ [WHERE ]
, :):
DELETE FROM friends WHERE name = ' '