首页 > 代码库 > Check restriction for mysql
Check restriction for mysql
Check restriction for mysql
Mysql does not suppot for check restriction but oracle does. Here using trigger we can achive the same restrction as check does.
Scenario:
Here is a IDcard field in table student with a restriction that the length of IDCrad must less than 18.
4 parameters we can use:
-
trigger-name: credit_tri
-
target-table:student
-
target-field:IDCard
-
error-msg:"length is above 18,cannot insert"
mysql> delimiter $ mysql> create trigger credit_tri before insert -> on student for each row -> begin -> declare msg varchar(200); -> if (new.IDCard > 18) then -> set msg = "length is above 18. Cannot insert."; -> signal sqlstate ‘HY000‘ SET message_text = msg; -> end if; -> end $
Check restriction for mysql
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。