mysql中什么情况下,表中可以没有主键?

2025-04-29 22:52:29
推荐回答(1个)
回答1:

可以使用下面的sql
select distinct table_name from columns where TABLE_SCHEMA = 'afs' and table_name not in (
select distinct table_name from COLUMNS
where TABLE_SCHEMA = 'afs' and (column_key = 'PRI' or column_key = 'UNI')
)