CREATE DEFINER=`root`@`%` PROCEDURE `c`()
BEGIN
DECLARE str varchar(20);
select username=str from cdb_members where uid=1;
select str;
END把查询出来的username=str??????????????
BEGIN
DECLARE str varchar(20);
select username=str from cdb_members where uid=1;
select str;
END把查询出来的username=str??????????????
BEGIN
DECLARE str varchar(20);
select username into str from cdb_members where uid=1;
select str;
END
改成 select username into str
BEGIN
DECLARE str varchar(20);
select username into @str from cdb_members where uid=1;
select @str;
END