important. ,,, (),, [19].
.
(. css, lt; style gt; -,):
{family: Garamond, serif;
} {size: 110% ;: red ;: white;
}
. note {: 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 ]:
) 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 -
CSS - HTML,. CSS. ,.
:
·. ,,,.
· CSS-. ,,.
·. , CSS-.
·. , CSS-, (),.
:
· (), - CSS.
· CSS-, HTML, CSS,. [20]
2.4.5 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 (length) [BINARY] VARCHAR (length) [BINARY]
: DATE TIME
: BLOB
: TEXT
: ENUM (value1, value2, value3 ,.) SET (value1, value2, value3,.).
_,: KEY (__ ,.) [_] (__ ,.) [_] (__ ,.) [INDEX] [_] (__ ,.) [INDEX] [_] (__ ,.)
[CONSTRAINT symbol] FOREIGN KEY [_] (__ ,.) [reference_definition] (expr)
(),,, __:
_ [(_)] FOREIGN KEY, CHECK REFERENCES Mysql. SQL -.
.
, (_),:
: TYPE={BDB | HEAP | ISAM | Inno DB? | MERGE | MRG_MYISAM | MYISAM}
: AUTO_INCREMENT=
: AVG_ROW_LENGTH=
(60): COMMENT= :MAX_ROWS=MIN_ROWS=
() CREATE - SELECT (select_).:
[IGNORE | REPLACE] SELECT.
(SELECT)
CREATE SELECT,,,.
Persons: gt; CREATE TABLE Persons (id INT PRIMARY KEY AUTO_INCREMENT, first_n...