(author) id FROM Personslast_name= bday= +1934 raquo ;;
Artifacts «» (author), Persons,.
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] __ =,
_ =,
: gt; INSERT INTO Personslast_name= , _ name= raquo ;;
Persons last_name «», first_name - «».
INSERT VALUES Mysql 3.22.5. _=Mysql 3.22.10.
.
INSERT VALUES INSERT SELECT, VALUES () SELECT. , DESCRIBE _.
,,. ,,.
expression,. ,:
Mysql gt; INSERT INTO _ (col1, col2)
VALUES (15, col1 * 2);
:
Mysql gt; INSERT INTO _ (col1, col2) (col2 * 2,15);
LOW_PRIORITY DELAYED,.. LOW_PRIORITY, INSERT,. ,,. INSERT DELAYED,.
INSERT IGNORE,, PRIMARY UNIQUE,. IGNORE,,.
UPDATE.:[LOW_PRIORITY] [IGNORE] _
SET _1=1
[, _2=2,]
[WHERE where_definition]
[LIMIT]
UPDATE. SET,. WHERE,,,.. ORDER BY,.
LOW_PRIORITY, UPDATE,.
IGNORE,,. , -,.
,,, UPDATE. , Death_date,:
Mysql gt; UPDATE Personsdeath_date=death_date + 1;
Mysql 3.23 LIMIT #,,.
, title «»:
Mysql gt; UPDATE Artifactstitle= Limit 1;
DELETE _, where_definition,.
DELETE WHERE,.
: [LOW_PRIORITY] FROM _
[WHERE where_definition]
[LIMIT rows]
, Persons, «» (bday) +2003:
Mysql gt; DELETE FROM Persons WHERE bday gt; 2003;
:
Mysql gt; DELETE FROM Persons WHERE 1 gt; 0;
,: gt; DELETE FROM Persons;
Mysql LIMIT DELETE,. , DELETE.
PHP, Mysql. Mysql, web-. ,? , SQL. web- html-,. [23].
Artifacts:
· (title);
· (author);
· (description);
· (alternative);
· (photo).
255 (.. VARCHAR (255)), - (TEXT), «» «» Persons Images [24].
2.5
.
Intel Celeron Dual Core 2600, 2, 8, 10/100/1000 /.
:
- Intel Xeon 3;
- 4;
- 72 2 RAID 1;
- (DVD-ROM);
- - FastEthernet 100;
Fibre Channel;
- - 1024x860;
- - «»;
- 104 ();
- 15 ».
Intel Celeron Dual Core 1000, 512, 10/100/1000 /.
TCP/IP.
Web- Web-. 2.3.
2.3. Web -
HP Pro 3500MT (H4L65ES) Intel Celeron Dual Core, 2.6, 4096 RAM, 500 HDD TP-Link TD-W8901N FastEthernet 100 1024x860 15 »
3. Web -
3.1
. , -. ,,.. ,..
, 50KB.... ,..-.
(Notepad) Web- phpdesigner... , (3.1). [25].
3.1 -
, (). 3.2.
3.3.
3.2 -
3.3 - «artposters.kz»
(3.4). ,.
MySQL php. , «» Register.php POST. register.php,,, users,.
3.4 -
(3.5).
3.5 -
[26].
«» (3.6).
3.6 -
MySQL php. B. «», [27].
3.2
-,. (-). , ().
- (,),. ,,,,, ..,. ,,,.. ,, -, ..
-. , (,:,, ..). ,. ,,, ... :,,, ..,.
... , -, -.
-,. ,. (. 1.2) _: _, _ _ (,).
-. ,,.-,. ,. [28].
Web- (3.7):
3.7 -
4...
