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'
转载请注明原文地址: https://ju.6miu.com/read-675482.html