禁止修改数据库中的某一列语句
防止userinfo 表中的name,age,tel,fax 等字段被撰改
roptriggerifexists`userinfo`;
set@old_sql_mode=@@sql_mode,sql_mode='';
delimiter//
createtrigger`userinfo`beforeupdateon`userinfo`foreachrowbegin
setnew.name=old.name;
setnew.member_id=old.member_id;
setnew.age=old.age;
setnew.tel=old.tel;
setnew.fax=old.fax;
end//
delimiter;
setsql_mode=@old_sql_mode;
/*!40014 set foreign_key_checks=1 */;
/*!40101 set character_set_client=@old_character_set_client */;
bitscn.com