我想你想要这样的东西：
DECLARE col_names CURSOR FOR SELECt column_name FROM INFORMATION_SCHEMA.COLUMNS WHERe table_name = 'tbl_name' ORDER BY ordinal_position;select FOUND_ROWS() into num_rows;SET i = 1;the_loop: LOOP IF i > num_rows THEN CLOSE col_names; LEAVE the_loop; END IF; FETCH col_names INTO col_name; //do whatever else you need to do with the col name SET i = i + 1; END LOOP the_loop;
