mysql> create table voteItem
-> (
-> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> title varchar(),
-> ticketNumber int
-> );
Query OK, rows affected (0.09 sec) mysql>
mysql> create table ticket(
-> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> voteItemID INT references voteItem(id) ,
-> ip varchar()
-> );
Query OK, rows affected (0.09 sec) mysql>
mysql> insert into voteItem values (null,'aaaaa',);
Query OK, row affected (0.03 sec) mysql>
mysql> select * from voteItem;
+----+-------+--------------+
| id | title | ticketNumber |
+----+-------+--------------+
| | aaaaa | |
+----+-------+--------------+
row in set (0.00 sec) mysql>
mysql> DELIMITER |
mysql>
mysql> CREATE TRIGGER testref AFTER INSERT ON ticket
-> FOR EACH ROW BEGIN
-> update voteItem set ticketNumber=ticketNumber+ where id = new.v
oteItemID;
-> END;
-> |
Query OK, rows affected (0.09 sec) mysql>
mysql> DELIMITER ;
mysql>
mysql> insert into ticket values (null,,'127.0.0.1');
Query OK, row affected (0.08 sec) mysql> select * from ticket;
+----+------------+-----------+
| id | voteItemID | ip |
+----+------------+-----------+
| | | 127.0.0.1 |
+----+------------+-----------+
row in set (0.00 sec) mysql> select * from voteItem;
+----+-------+--------------+
| id | title | ticketNumber |
+----+-------+--------------+
| | aaaaa | |
+----+-------+--------------+
row in set (0.00 sec)
摘自csdn论坛(http://bbs.csdn.net/topics/300203458)。