– . . , . , – , . .
, . . , .
, ( ). - . : Firebird, Interbase, IBM DB2, MS SQL Server, Sybase, Oracle, PostgreSQL, , MySQL. – MySQL, SQL. , .
- - , - , , . Microsoft Access, Borland Paradox.
,
, . . – . , , . - , - .
OpenEdge, SQLite, BerkeleyDB, Firebird, Sav Zigzag, Microsoft SQL Server Compact, , MySQL, - . , .
MySQL
MySQL , . , .
, . . MySQL. , . InnoDB .
ODBC . . , , – . , MySQL, -.
, , MySQL, SQL , . , - , . .
, . . MySQL, , , , . , . , , , .
, , MySQL. . MySQL. , , .
, MySQL. , , . . . .
, . help, MySQL.
, , . MySQL , . root, .
MySQL root MySQL. .
help. .
. . use. . - test. : use test.
create, database . : create database Name_of_database. use.
, , , MySQL . show. , , : show databases. , tables.
, , SQL , . , , SQL, ( ) MySQL. Windows .
, , , . create . . , , drop, . : drop name_of_your_table.
. , Windows, MySQL Linux. , , .
Select
, , - select. . : select * from table_name. , , .
, - MySQL . PHP- SQL, - . “*” select, , , . join, . , , .
Sometimes a situation occurs when the response received from the database server contains duplicate data. In order for the user to see only unique entries, the distinct clause is used. It is placed in front of the list of requested fields and serves as an aid to hide duplicates.