CREATE TRIGGER t_afterdelete_on_t_user
AFTER INSERT ON t_user
FOR EACH ROW
BEGIN
UPDATE t_user SET NEW.member_no = NEW.user_id;
END;执行不了,请大家帮忙看看问题。下面是错误信息
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'END'
at line 1
解决方案 »
- 数据类型转换
- InnoDB并发压力下出现SQL Error: 1205错误“死锁”
- 初级提问:一个记录用户帐户信息的表适合用MyISAM还是InnoDB?
- 大家帮忙看看这个存储过程有什么问题
- mysql有没有象oracle这样的sql(select level,* from table connect by start 条件)
- 高分求教:MySql 4.0.18远程连接的问题
- select * from tablename limit 10;如何让结果又大到小排序(类似order by desc)?在线等!!急!!
- 请帮我解释一下MySQL的表格类型。谢谢!也算送分。:)
- 这个查询该如何写
- 如何把MYSQL的ROOT密码修改?
- 求解???创建表时带括号的字段如何创建
- mysql 查询分组语句按时间显示
CREATE TRIGGER t_afterdelete_on_t_user
AFTER INSERT ON t_user
FOR EACH ROW
BEGIN
UPDATE t_user SET NEW.member_no = NEW.user_id;
END;
//
delimiter ;
AFTER INSERT ON t_user
FOR EACH ROW
UPDATE t_user SET NEW.member_no = NEW.user_id;