获取目标表的主键

    xiaoxiao2021-04-18  66

    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

    最新回复(0)