MYSQL

update lithoeap_productrule t INNER JOIN lithoeap_s2 a ON t.Product=a.Product AND t.Layer=a.Layer SET t.SchemaRule=a.RuleID 

 
 create user 'miao' @'%' identified by 'xxxxxxxxxxx333333';
 
 
 grant all on *.* to 'miao' @'%' ;