t; p gt;
, -, -. , (,)..
: JavaScript [18].
,,.
. («.»), («#»), -.
CSS,,,,,,,. CSS:,,.
.. CSS.
CSS HTML. , CSS, -,. ,, CSS -, p CSS,, p, p CSS (, color: green;), -,.
, - HTML CSS,,..
;
,.
,. ,:
·,;
·,,;
·, (. «»), style. , -,,..:
· (#id) - ((1,0,0,0) CSS);
· ([attr], [attr=«value»]) - ((0,1,0,0) CSS);
· (.class) (: pseudoclass) - ((0,0,1,0) CSS);
· (H1, INPUT) - ((0,0,0,1) CSS).
,,, (1,0,0,0), -? , (0,10,0,0), (0,1,0,0),, (0,0,10,0), (0,0,1,0), (0,0,0,10 ). ,,,.
·, style;
·,,! important. ,,, (),, [19].
.
(.css, lt; style gt; «» -,):
p {family: Garamond, serif;
} {size: 110% ;: red ;: white;
} {: red ;: yellow; weight: bold;
} # paragraph1 {: 0;
}: hover {decoration: none;
}
# news p {: blue;
}
[type=«button»] {color: green;
}
CSS p, h2.note, p # paragraph1, a: hover, #news p [type=«button»]:
1) HTML- p () -. Garamond,,, - («serif»).
2) HTML- h2 ()..
), class note raquo ;. ,: Lt; p gt;
) p, id paragraph1. (margin).
) hover a -. , A. ,.
), p, - id, «news» (#news p -,. 5).
), type button. , Lt; input type=«button» gt; (),.
CSS - HTML,. CSS. ,.
:
·. ,,,.
· CSS-. ,,.
·. , CSS-.
·. , CSS-, (),.
:
· (), - CSS.
· CSS-, HTML, CSS,. [20]
MySQL
-,,,.. (). ,.
,,,. ,,..-.
. , (,,,),,.
, (,),..
: Mysql, PostgreSql.-,,, ()
.
: Cache, GemStone (Servio Corporation), ONTOS (ONTOS).
-.- IBM DB2 for Common Servers, Oracle8.
(primary key, PK) -,. , -, -, (), -,.
,.
, .... ,,,,. ,. , ...,,, .... , (). , (,, PK),, (,, PK).
... (). id (),,. ,.
,.
,: (Persons), (Artifacts), (Images).
id (). Artifacts author,, Persons. Persons. , Persons Artifacts photo, Images. Images Persons-Images Artifacts-Images. photo 10,, id=10. , ().
,, -. ,,,,,, ...
().. ,,. ,. ,. ,,,. , 1000, 100. , 1000,,.. ,,. (,).
Mysql,: PRIMARY, UNIQUE, INDEX, (KEY) (INDEX). B -.- (), (.. NOT NULL). , .- (),, .- (). Mysql,, .-. , SQL. Mysql -, ... ,,,,,.
Mysql,. (, PHP). PhpMyAdmin. Mysql.
:
·,, ();
·,,,;
·, ();
·.
. , ().
-,,,. SQL CREATE TABLE, ALTER TABLE DROP TABLE. [21]
CREATE TABLE.. ,.
Mysql 3.22 __. _. ,.
Mysql 3.23 TEMPORARY. ,. , (,). Mysql 4.0.2 CREATE TEMPORARY TABLES.
Mysql 3.23 IF NOT EXISTS,,. ,.
.
: [TEMPORARY] TABLE [IF NOT EXISTS]
_ [(_,)]
[_] [select _]
_,. (NULL),,. ,,. NULL, NOT NULL,, NULL. (AUTO_INCREMENT),, (NULL, ..
) 0., ._INCREMENT 1. Mysql. (_):
_ [NOT NULL | NULL]
[DEFAULT __]
[AUTO_INCREMENT] [PRIMARY KEY]
[reference_definition]
(_):
: INT [(length)] [UNSIGNED] [ZEROFILL]
: REAL [(length, decimals)] [UNSIGNED] [ZEROFILL]
: CHAR...
