|
- USE RADIUS;
- CREATE TRIGGER bindmac
- AFTER INSERT
- ON radacct FOR EACH ROW
- BEGIN
- IF rm_users.usemacauth = 0 THEN
- UPDATE rm_users set mac = radacct.calledstationid , usemacauth = 1 WHERE username=radacct.username;
- END IF;
- END;
复制代码
数据库radians中表radacct和rm_users
表radacct中有字段username和calledstationid
表rm_users中有username,mac,usemacauth
问题是,想让表radacct每插入一条数据时检查username和表rm_users.username相同值的数据条目中的usemacauth值是否为0
如果是则更新rm_users.mac为radacct.calledstationid,如果是1
这个该怎么写? |
|