SQL - , SELECT, INSERT, UPDATE DELETE.
, 2001cu 1, SQL:
SELECT cust_email FROM customers WHERE custjd = '2001cu'
:
SELECT _ FROM _ [ WHERE ]
, . , customers :
SELECT cust_email FROM customers
products :
INSERT into products VALUES ('1009pr', 'Red Tomatoes', '1.43');
, :
DELETE FROM products WHERE prod_id = 1009r';
SQL . , - (PHP, Java Perl) , , . Web.
. , MySql
products : ID, Name, Price. Name TEXT, - INT:
CREATE TABLE IF NOT EXISTS `products` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Name` text NOT NULL,
`Price` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
, 2 .
Mysql- :
INSERT INTO `products` (`ID`, `Name`, `Price`) VALUES
(1, '', 35),
(2, '', 27),
-
MySql web-.
"product_list.php" :
<!doctype html>
<html lang="ru">
<head>
<title>MySQL</title>
</head>
<body>
<?php
$host="localhost"; //
$user="root"; //
$pass="123456"; //
$db_name="my_db"; //
$link=mysql_connect($host,$user,$pass); //
mysql_select_db($db_name,$link); //
?>
</body>
</html>
. ( </body>) :
<table border='1'>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<?php
$sql = mysql_query("SELECT `ID`, `Name`, `Price` FROM `products`", $link);
while ($result = mysql_fetch_array($sql)) {
echo '<tr><td>'.$result['ID'].'</td><td>'.$result['Name'].'</td><td>'.$result['Price'].' </td></tr>';
}
?>
</table>
.2
-, .