【Vegas原创】BugFree删除项目的方法

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 642

Server version: 5.1.40-community MySQL Community Server (GPL) 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 

mysql> use bugfree

Database changed

mysql> select * from bugproject;

+-----------+--------------+------------+-------------+---------------------+

| ProjectID | ProjectName  | ProjectDoc | ProjectPlan | AddDate             |

+-----------+--------------+------------+-------------+---------------------+

|         1 | Mission Test |            |             | 2004-09-22 11:39:30 |

|         2 | HIS(PB)      |            |             | 2009-12-17 10:27:35 |

+-----------+--------------+------------+-------------+---------------------+

2 rows in set (0.00 sec) 

mysql> delete From bughistory Where BugID in

    -> (

    -> Select bugID From buginfo Where ProjectID=1

    -> );

Query OK, 14 rows affected (0.02 sec) 

mysql> Delete From buginfo Where ProjectID=1;

Query OK, 11 rows affected (0.00 sec) 

mysql> Delete From bugmodule Where ProjectID=1;

Query OK, 11 rows affected (0.00 sec) 

mysql> Delete From bugproject Where ProjectID=1;

Query OK, 1 row affected (0.00 sec)