开发者

is this MySql assertion correct?

开发者 https://www.devze.com 2023-02-08 14:19 出处:网络
is the following MySql assertion syntactically correct? create assertion RD1_assert checkUser.num_video=select count(*)

is the following MySql assertion syntactically correct?

create assertion RD1_assert

check User.num_video = select count(*)

from Video

where Video.开发者_如何学编程user= User.Nick


No, because MySQL does not support assertions!


Mysql does not support assertion so you could use trigger and store procedure instead of assertion.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号