Question

怎样用SQL给电话号码添加约束

长度是11或格式为'010-6545351'

Answer 1

设你的列叫pho_num 表叫tablename
建立一个名叫length_11的check类型约束

alter table tablename
add constraint length_11
check (
len(pho_num)=11
)

Answer 2

alter table tablename
add constraint length_11
check (
len(pho_num)=11 and pho_num like'[0-9][0-9][0-9]_[0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
)