mysql动态获取中文字段名

无无聊聊写了一个mysql动态获取中文字段名的存储过程
还有许多要优化的地方

CREATE PROCEDURE P_TABLE_NAME_CHS(
IN v_table_name VARCHAR(100)
)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN
DECLARE vstrSql VARCHAR(5000) ;

set @num:=1;
set @v_column_name=’’;
select COUNT(1) into @count from information_schema.columns where table_name=v_table_name and ordinal_position=@num;
#SELECT @COUNT;

WHILE @count>0 do
select COUNT(1) into @count from information_schema.columns where table_name=v_table_name and ordinal_position=@num;
select column_name into @v_column_name_temp from information_schema.columns where table_name=v_table_name and ordinal_position=@num;
select column_comment into @V_column_comment from information_schema.columns where table_name=v_table_name and o