sql
SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
TABLE_NAME= '表名'
AND COLUMN_KEY = 'PRI';
存储过程:每个类型必须定义长度
CREATE PROCEDURE getPkByTableName(in tableName VARCHAR(255))
BEGIN
SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_name = tableName
AND COLUMN_KEY = 'PRI';
END;
方法:参数不能带 in out inout 的状态修饰
CREATE FUNCTION getPkByTableName ( tableName VARCHAR(255)) RETURNS VARCHAR (255)
BEGIN
DECLARE pk VARCHAR(255);
SELECT
COLUMN_NAME INTO pk
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_name = tableName
AND COLUMN_KEY = 'PRI';
RETURN pk;
END;