我的触发器是
CREATE TRIGGER addName
after INSERT ON student FOR EACH ROW
begin
insert into oneclass(OneClassID,OneClassName) values(11,'ddd');
end;触发器运行完之后 再运行 insert into student(StuName) values('dd');
报错 寻找解决办法 谢谢
CREATE TRIGGER addName
after INSERT ON student FOR EACH ROW
begin
insert into oneclass(OneClassID,OneClassName) values(11,'ddd');
end;触发器运行完之后 再运行 insert into student(StuName) values('dd');
报错 寻找解决办法 谢谢
解决方案 »
- 关于mysql主从服务器的两个问题 请大牛指教
- [征集]分组取最大N条记录方法征集,及散分(新年,升星)
- 谁能跟我解释一下数据库预处理?
- 如何取得数据库服务器的名称?
- Windows 2003下的ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
- float类型的字段如何使插入的记录值为空呢???
- 使用MYSQL如何建立DNS
- 如何将几十张表集合到一张表中?
- mysql left join的条件是计算后得到的应该怎么写
- mysql自定义变量无法求和
- 请问,MYSQL如何自动定时备份远程服务器数据库到本地(非整个数据库,是部分关键表)
- ===============mysql 取离现在时间最近的数据===========
FOR INSERT
ON student
AS
begin
insert into oneclass(OneClassID,OneClassName) values(11,'ddd');
end;
C:\>mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.51b-community-nt MySQL Community Edition (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> use test
Database changed
mysql> create table student (id int not null);
Query OK, 0 rows affected (0.27 sec)mysql> create table oneclass(OneClassID int, OneClassName varchar(20));
Query OK, 0 rows affected (0.02 sec)mysql> delimiter ||
mysql> create trigger addName after insert on student for each row
-> begin
-> insert into oneclass(OneClassID,OneClassName) values(11,'ddd');
-> end||
Query OK, 0 rows affected (0.06 sec)mysql> delimiter ;
mysql>
mysql> insert into student values (23);
Query OK, 1 row affected (0.03 sec)
mysql> select * from oneclass;
+------------+--------------+
| OneClassID | OneClassName |
+------------+--------------+
| 11 | ddd |
+------------+--------------+
1 row in set (0.04 sec)mysql>
谢谢