.


:




:

































 

 

 

 


MySQL




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

 

, . , "", " ".

- "" " ".

"".

 

 





:


: 2017-02-11; !; : 743 |


:

:

, .
==> ...

930 - | 863 -


© 2015-2024 lektsii.org - -

: 0.011 .