4
. PHP
: PHP, .
MySQL
, , , . PHP-, fgets(). , , echo print(). Web-, . , Web- . Web- , PHP- , .
SQL, , . , , , SQL .
, , . ( ) . ( ) , .
, , , , DB2, FrontBase, Informix, InterBase, mySQL, MS SQL Server, MySQL, Oracle, ODBC, PostgreSQL Sybase. , PHP-, Internet- .
, MySQL.
MySQL , http://www.MySQL.com. Windows, Unix.
, , PHP-, .
SQL- CREATE DATABASE, :
CREATE DATABASE < >;
, , , . . , SQL:
|
|
CREATE DATABASE ``;
, . , . (, , ) . , , , . SQL:
CREATE TABLE ``.``(
`_` INT (11) DEFAULT NULL,
`` VARCHAR (40) DEFAULT NULL,
`_` INT (11) DEFAULT NULL,
`__` DOUBLE DEFAULT NULL
)
TYPE = MYISAM;
CREATE TABLE :
CREATE TABLE < >
(< >< > [< >],
< > < >
[< >])
, , SQL- INSERT, , INSERT:
USE ``;
INSERT INTO `` VALUES (1, ' 1', 100, 258.23);
INSERT INTO `` VALUES (2, ' 2', 200, 1844.51);
INSERT INTO `` VALUES (3, ' 3', 300, 855.15);
INSERT INTO `` VALUES (4, ' 4', 200, 891.56);
INSERT INTO `` VALUES (5, ' 5', 100, 1844.51);
INSERT INTO `` VALUES (6, ' 6', 600, 567.01);
INSERT INTO `` VALUES (7, ' 7', 250, 675.28);
INSERT :
INSERT INTO < >
VALUES {1, 2,..., N);
SQL- SELECT. , :
SELECT * FROM ``.``
, PHP- SQL-.
"dbForge Studio for MySQL"
养 " ", :
:localhost
:root
:password
, . , "", " ".
- "" " ".
"".