is the following MySql assertion syntactically correct?
create assertion RD1_assert check User.num_video = select count(*) from Video where Video.开发者_如何学编程user= User.NickNo, because MySQL does not support assertions!
Mysql does not support assertion so you could use trigger and store procedure instead of assertion.
精彩评论