create trigger geo_updtime after update on tbl_geofence for each row begin update tbl_sys set geofence_updatetime=to_date(select st.update_time from information_schema.tables st where table_name='tbl_geofence') where sys_id=1 end;
CREATE TRIGGER geo_updtime after update on tbl_geofence FOR EACH ROW update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1;这个正确。但是 加个begin end 就不行了:CREATE TRIGGER geo_updtime after update on tbl_geofence FOR EACH ROW begin update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1; end;
delimiter //CREATE TRIGGER geo_updtime after update on tbl_geofence FOR EACH ROW begin update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1; end; //
delimiter //CREATE TRIGGER geo_updtime after update on tbl_geofence FOR EACH ROW begin update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1; end; //这个语法也通不过: 在 mysql的 可视化 LBS_HDB中 语法通不过
after update on tbl_geofence
FOR EACH ROW
update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1;这个正确。但是 加个begin end 就不行了:CREATE TRIGGER geo_updtime
after update on tbl_geofence
FOR EACH ROW
begin
update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1;
end;
after update on tbl_geofence
FOR EACH ROW
begin
update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1;
end;
//
否则MYSQL看到;就开始提交了。
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
after update on tbl_geofence
FOR EACH ROW
begin
update tbl_sys set geofence_updatetime=to_date(2012-12-12) where sys_id =1;
end;
//这个语法也通不过: 在 mysql的 可视化 LBS_HDB中 语法通不过