SELECT
k.column_name
FROM
information_schema.table_constraints t
JOIN information_schema.key_column_usage k USING (
constraint_name,
table_schema,
table_name
)
WHERE
t.constraint_type = 'PRIMARY KEY'
AND t.table_schema = 'tableSchema'
AND t.table_name = 'tableName'
获取目标表的主键
最新推荐文章于 2023-09-10 23:32:05 发布