. , . . , , . , , .
15. . . . . .
Table . . ixDescending , , . ixDescending , . , , IndexName. . Paradox . dBase .
, , ORDER BY. : , , , , . .
, SELECT.
. - DESC. . , , . , , . . , . , , .R FindFirst, FindLast, FindNext FindPrior, , .
17. SQL , . SQL , : 1. ; 2. ; 3. ; 4. ; 5. , . , , , .
|
|
|
16. () , ( ), . , , . , . , . , SQL, SQL-. , , SQL, . , , PostgreSQL, Interbase, Firebird, Microsoft SQL Server, Oracle, :1. , (, , );2. , (, );3. (, , );4. (join) (, , , , , , , , , , );5. , (, );6. (, , , ); .
| 19) . SQL, 1)SELECT ; 2)INSERT ; 3)UPDATE ; 4)DELETE ; , , - . SELECT . , SELECT, JOIN UNION. , . SELECT . , SELECT. , , . , , : SELECT * FROM table_name. INSERT . INSERT . INSERT: INSERT INTO table_name (column1, column2, column3) VALUES (data1, data2, data3); UPDATE WHERE: UPDATE , , . , WHERE. UPDATE table_name SET column1 = data1, column2 = data2 WHERE column3 = data3; WHERE , , . . UPDATE table_name SET FirstName = WHERE FirstName = AND LastName = ; DELETE . , UPDATE , NULL . , DELETE WHERE, . DELETE FROM table_name WHERE column1 = data1; , 20. SQL ), . SQL:1) ;2) ( , ); 3) . SQL , , , |
21.SQL- . , :SELECT __ FROM _ WHERE _
|
|
|
. - . , id.
SELECT * FROM table_1, table_2 WHERE table_1.id > table_2.user_id
2 SQL-: . , .SELECT * FROM users, products WHERE users.id = products.owner_id
: users. id products, , owner_id id users. , . .
, SQL- , , .
22. . SQL, 1)SELECT ; 2)INSERT ; 3)UPDATE ; 4)DELETE ; , , - . SELECT . , SELECT, JOIN UNION. , . SELECT . , SELECT. , , . , , : SELECT * FROM table_name. INSERT . INSERT . INSERT: INSERT INTO table_name (column1, column2, column3) VALUES (data1, data2, data3); UPDATE WHERE: UPDATE , , . , WHERE. UPDATE table_name SET column1 = data1, column2 = data2 WHERE column3 = data3; WHERE , , . . UPDATE table_name SET FirstName = WHERE FirstName = AND LastName = ; DELETE . , UPDATE , NULL . , DELETE WHERE, . DELETE FROM table_name WHERE column1 = data1; ,
|
|
|
