, , .
. , .
, , , . . , , .
, :
?
() ?
?
?
?
?
10 : , . - , . . , , . . . , , , ( ) .: - - , , , . - - , , , , . . - , , , .
, .
- . :CREATE [UNIQUE] INDEX <_> ON <_> (<_>,...) <_> , , . B- . . UNIQUE . , . , . . , publications , . authors :
|
|
|
CREATE INDEX au_names ON authors (author);
:
CREATE INDEX au_index ON authors (au_id);
CREATE INDEX title_index ON titles (title_id);
CREATE INDEX pub_index ON publishers (pub_id);
CREATE INDEX site_index ON wwwsites (site_id);
. , ..
:DROP INDEX <_>
12) SQL- :INSERT INTO users (login, pass) values('TestUser', '123456') "INSERT INTO", , . , . "values" , . . , SQL-:UPDATE users SET login = 'TestUser2', pass='1234560' WHERE login='TestUser'
, "WHERE", . "UPDATE", , "SET" , . , : " ?". "WHERE". , "login" "TestUser". , , ! , . SQL- : DELETE FROM users WHERE login='TestUser2' "DELETE FROM" , . "WHERE". , . , , "WHERE", . () . sql UPDATE, : UPDATE [LOW_PRIORITY] [IGNORE] _ set _ = _,..... [WHERE - ] [ORDER BY ] [LIMIT ] SELECT * FROM table_name WHERE () [order by field_name [desc][asc]] table_name, . , order by , ( desc, ). order by . *. , , . , , . *.
|
|
|
13) ; . , , . title_id titles ( ) title_id sales ( ). . , . . , . , publishers titles : , . , . , , . , , . , . , , . , authors titles titleauthors. titleauthors au_id ( authors) title_id ( titles). , . , . , . : . . , . , . , , . , , . : 1) , , . 2) . 3) . 4) . 5) (...) . 6) , . 7) , . . 8) OK, .
: 1) , , 2) . 3) . 4) . : 1) . , : . . , , . . . 2) - . , . ? , . ? -, . Delphi AutoIncrement, SQL Server 2 - TimeStamp Identity . SQL Server'. , " ", . ? . - , " , ". - . 3) . ! , . 4) - ,
|
|
|
