触发器学习

触发器语法

Create trigger  tri_name

ON {table|View}

[With encryption]{

{{for|after|instead of}{insert|update|delete}

[with append]

[not for replication]

as

[{if update(colum)

[{and|or}update(colum)]

[...n]|if(columns_updated() updated_bitmask)

colum_bitmask[...n]

}]

sql_statement[...n]

}

}

 

 

 

 

 

 

 

}