比如
DECLARE mycur CURSOR FOR
SELECT
`column1`,
`column2`,
`column3`
FROM
`foo`.`bar`;
现在只想从游标里取出column1,可以这样写么?
DECLARE strColumn1 VARCHAR(16);
OPEN mycur;
FETCH
`column1`
FROM
mycur
INTO
strColumn1;
CLOSE mycur;