Do not modify a column of statements in the database

Do not modify a column of statements in the database to prevent ROPTRIGGERIFEXISTS 'userinfo' from being written into the name, age, tel, fax and other fields in the userinfo table; SET @ OLD_ SQL _MODE = @ SQL _MODE, SQL _MODE = ''; DELIMITER // CREATETRIGGER 'userinfo' BEFOREUPDATEON 'userinfo' FOREACHROWBEGINsetnew. 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 */;