1:语法-- col_name列名 var_name变量名 可赋值给多个
SELECT col_name[,...] INTO var_name[,...] FROM table_name;
2:使用;需注意查询值必须返回唯一,如下使用时 如果不加 Limit 1就会返回多个结果赋值时会出错,-- 简单查询示例
select `code` into @bl from c_ufmall_herbal_status limit 1;
select @bl;
-- 在存储过程/函数中使用
-- SELECT GROUP_CONCAT(p_id),GROUP_CONCAT(NAME) INTO sTempChd,sTempChdName FROM m_ufmall_category
CREATE FUNCTION `queryUpChildCategoryInfo`(categoryId INT)
RETURNS VARCHAR(5000) CHARSET utf8
BEGIN
DECLARE sTemp VARCHAR(5000);
DECLARE sTempChd VARCHAR(5000);
DECLARE sTempChdName VARCHAR(5000);
SET sTemp='',sTempChdName = '';
SET sTempChd = categoryId;
WHILE sTempChd IS NOT NULL DO
IF sTemp = '' AND sTempChdName <> ',' THEN
SET sTemp = sTempChdName;
ELSEIF sTempChdName <> '' THEN
SET sTemp= CONCAT(sTemp,',',sTempChdName);
END IF;
SELECT GROUP_CONCAT(p_id),GROUP_CONCAT(NAME)
INTO sTempChd,sTempChdName FROM m_ufmall_category
WHERE delete_userid = 0 AND id = sTempChd;
END WHILE;
RETURN sTemp;
END