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 "@"
试试select @name:=name from tablename where id=1
SELECT @varname=columnname FROM tablename 上述语句在SQL SERVER 2008里可执行通过。
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级别的,只能在当前连接下访问。
select "name" into @var from serviceclientsinfo.conactnametable where owner='b';
select @var;
我用的是postgresql,使用上面语句报错ERROR: syntax error at or near "@"
上述语句在SQL SERVER 2008里可执行通过。
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级别的,只能在当前连接下访问。