, . .
, , .
.
UniVers, Budda Dasdb.
, . .
.
Ess-base Arbor Software, Oracle Express Server Oracle .
. , , . . , , :
. Borland Microsoft , : .
:
;
- ;
- ;
- .
. . . . . . .
( ) , , Ļ; . ( Microsoft Access), -, , . , .
.
|
|
CASE Studio . "-" (ERD) (DFD). ER- : ( ) . - .
, , , , . , ER- (Reverse Engineering) , ODBC ADO-.
, , .. CASE Studio - ( ), ( ), , , (); . ( Model - Database Convertion) .
, . 9.3, . ( ) . : (restrict) .
() (), () , .
, .
1. : , , , .
2. : .
3. : , , .
:
- ( , ..).
- ( , ). :
|
|
- , ( );
- ( ) ;
- ( , , );
- ;
- () ;
- (, , , ) .
- . .
- , , , .
- , .
- , , .
.
.
, . .
, , , .
( , , , - .)
- , .
- - , , .
, , .
SQL
CREATE DATABASE
:
CREATE DATABASE [IF NOT EXISTS] db_name;
db_name - .
USE
C MySQL, .
USE db_name;
db_name .
CREATE TABLE
.
CREATE TABLE table_name [[create_definition,...)] [table_options];
table_name ; create_definition , .
DESCRIBE
:
DESCRIBE table_name;
table_name , .
ALTER TABLE
. , , .
ALTER TABLE table_name alter_spec;
DROP TABLE
:
DROP TABLE table name [, table name,... ];
|
|
DROP DATABASE
, :
DROP DATABASE database_name
new_base SQL-
mysql> DROP DATABASE forum;
INSERT INTO... VALUES
. :
INSERT INTO table_name VALUES (values,...);
VALUES .
DELETE
table_name , definition , .
DELETE FROM table_name [WHERE definition];
new_table.
mysql> DELETE FROM new_table;
DELETE, UPDATE SELECT WHERE, , .
SELECT
:
SELECT column,... [FROM table WHERE definition] [ORDER BY col_name [ASC I DESC],... ] [LIMIT [ offset ], rows];
column . .
, (*).
UPDATE
table .
UPDATE table SET col_namel=exprl [, col_name2=expr2...] [WHERE definition] [LIMIT rows];
SHOW
SHOW , MySQL.
SHOW CHARACTER SET , MySQL.
SHOW COLUMN TYPES , MySQL.
mysql> SHOW FIELDS FROM new_table;
SHOW DATABASES SHOW TABLES , , .
Visual FoxPro
ADD TABLE | . , , . |
APPEND | . |
APPEND FROM | . |
BROWSE | . |
CLOSE ALL | , , 1. , FCREATE() FOPEN(). . CLOSE ALL , SET PRINT. |
CLOSE DATABASES | . , , , , 1. |
CLOSE TABLES | , , . |
COUNT | , . |
CREATE | Visual FoxPro. |
CREATE QUERY | . |
CREATE TABLE | . |
DELETE | . |
DISPLAY STRUCTURE | . |
DISPLAY TABLES | , , . |
EDIT | . |
MODIFY QUERY(STRUCTURE) | , ( ). |
|
|