1. find_in_set('''$ip''',CONCAT('''', REPLACE( REPLACE(w_ip,',',''',''') ,'-',''',''')
2. grant all privileges on *.* to test@* identified by '123456';
3. 触发器中无法使用事务,也没有办法进行异常处理。
4. 替换字符串,update business set bus_hidden_time=REPLACE\(bus_hidden_time,',201503',''\) where bus_id=$1;