如何将select结果赋值到一个变量里？

[shisoftgenius]

比如 select "name" from serviceclientsinfo.conactnametable where owner='b'
我希望出来的结果的第一行赋值给变量id?

[ACMAIN_CHM]

select colName into @var from table1 where id=10

[ACMAIN_CHM]

MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
[Quote]mysql> delimiter //

mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
-> BEGIN
-> SELECT COUNT(*) INTO param1 FROM t;
-> END
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

mysql> CALL simpleproc(@a);
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @a;
+------+
| @a |
+------+
| 3 |
+------+
1 row in set (0.00 sec)
[/Quote]

[xxy_aldrich]

学习了。。。。

[shisoftgenius]

[Quote=引用 1 楼 acmain_chm 的回复:]

select colName into @var from table1 where id=10
[/Quote]

insert into serviceclientsinfo.conactnametable ("name","owner") values ('a','b');
select "name" into @var from serviceclientsinfo.conactnametable where owner='b';
select @var;

我用的是postgresql，使用上面语句报错ERROR: syntax error at or near "@"

[liqiang8]

试试select @name:=name from tablename where id=1

[urakvv7]

SELECT @varname=columnname FROM tablename

上述语句在SQL SERVER 2008里可执行通过。

[luketty]

2楼 正解

[zuoxingyu]

mysql> select name into @A from area limit 1;
Query OK, 1 row affected (0.00 sec)

mysql> select @A;
+------+
| @A   |
+------+
| 北京     |
+------+
1 row in set (0.00 sec)

mysql>

不过这样的@a是session级别的，只能在当前连接下访问。