MySQL> insert into tbl (idx,UserName,LastName,FreeText) values (1,'Rafi','Ton','Just a test');<回车>
好，现在我们可以再看一下表中的内容：
MySQL> select * from tbl;<回车>
这次的结果是：作者: 江南细雨 时间: 2006-10-12 09:46
+------+----------+----------+-------------+
| idx | UserName | LastName | FreeText |
+------+----------+----------+-------------+
| 1 | Rafi | Ton | Just a test |
+------+----------+----------+-------------+
1 row in set (0.00 sec)
现在我们可以看到表的结构和每一个单元格的内容。
现在我们想删除数据。为了实现我们应该键入：
MySQL> delete from tbl where idx=1 limit 1;<回车> Query OK, 1 row affected (0.00 sec)
<p></p>
<ul>
<li><a href="index.PHP3">Home</a>
<li><a href="add.PHP3">Add a new entry to the DataBase</a>
<li><a href="edit.PHP3">Edit an entry</a>
<li><a href="del.PHP3">Delete an entry from the DataBase</a>
</ul>
include的语法是：
Include ('included_text_file');
现在我们可以用?>来关闭PHP部分，并且用</body></html>来结束html页面。
使用表单增加数据
让我们看一下下面的代码：
--------------------------------------------------------------------------------
<html>
<head><title>Add an entry to the database</title>
</head>
<body bgcolor=#ffffff>
<?
if ($UserName)
{
mysql_connect() or die ("Problem connecting to DataBase");
$query = "insert into tbl values ('$idx','$UserName','$LastName','$FreeText')";
$result = mysql_db_query("example", $query);
echo "Data inserted. new table:<br><p></p>";
$query = "SELECT * FROM tbl";
$result = mysql_db_query("example", $query);
$query = "update tbl set idx='$idx',UserName='$UserName', LastName='$LastName',FreeText='$FreeText' where idx='$idx' and UserName='$UserName' and LastName='$LastName' and FreeText='$FreeText'";
mysql_connect() or die ("Problem connecting to DataBase");
$query = "delete from tbl where idx='$idx' and UserName='$UserName' and
LastName='$LastName' and FreeText='$FreeText'";
