2
MySQL
. 2
1. .. 3
3. .. 7
3.1 SQL. 8
3.2 SQL. 10
3.3 . 10
4. MySQL. 13
4.1 .. 14
4.2 MySQL. 14
4.3 -.. 14
4.3.1 .. 15
4.3.2 -. 15
4.3.3 . 16
4.3.4 . 17
4.3.5 . 19
4.3.6 -. 20
4.3.7 . 20
4.3.8 . 21
4.3.9 . 23
4.3.10 . 24
4.3.11 MySQL Workbench. 25
5. MySQL 28
.. 31
, . ( ). , , , . , , , . . , , , .
, . :
, ;
, ;
.
.
() - , .
|
|
, , :
-
:
( )
( )
:
-
- -. ( ). . . . : ; ; , . , .
- .
: Microsoft Access, Paradox, dBase, FoxPro, Visual FoxPro.
-
- , . - . - . : ; ; , .
: Oracle, Firebird, Interbase, IBM DB2, Informix, MS SQL Server, Sybase Adaptive Server Enterprise, PostgreSQL, MySQL, Caché, .
, , . . . SQL[1] .
: OpenEdge, SQLite, BerkeleyDB, Firebird Embedded, Sav Zigzag, Microsoft SQL Server Compact, .
, , - . - , - , , .. : , . , , , , .
|
|
- .
SQL-[2] . . :
1 SQL-
IBM DB2 Universal Database | , , . | . |
Oracle Database | . . | . |
Microsoft SQL Server | , . . | (Win32). |
Borland InterBase | . . . | . |
PostgreSQL | . . . | . |
MySQL | . . . | . |
. , , .
MySQL-, , .
. :
.
.
. , , SQL, .
, :
o CREATE
o DESC
o INSERT
o ALTER
o UPDATE
o DELETE
:
o
o
o
:
, , MySQL Workbench.
SQL
SQL (Structured Query Language).
SQL(Structured Query Language) MySQL.
SQL 1992 . ( - SQL (1992) (International Standart Database Language SQL), - SQL/92, SQL-92, SQL2). , , 600 . .
SQL . , "", SQL. . .
, , SQL . , , . , , - SQL. , .
|
|
SQL , , , "" "", "" - "", "" - "" "".
SQL, , . , , SQL . .
SQL . , SQL.
SQL , , - , , , . SQL .
SQL , :
DDL (Data Definition Language) - .
DML (Data Manipulation Language) - .
, .
SQL , . , , :
( );
;
()
;
.
, SQL- . , :
, ( );
, ( ) .