你的函数用错了,应该是concat(string1,string2,...)
mysql> create procedure `p4`()
-> begin
-> set sql_mode='ansi';
-> set @a=concat('haha','wawa');
-> end
-> //
Query OK, 0 rows affected (0.34 sec)mysql> call p4()//
Query OK, 0 rows affected (0.04 sec)mysql> select @a//
+----------+
| @a |
+----------+
| hahawawa |
+----------+
1 row in set (0.00 sec)
mysql> create procedure `p4`()
-> begin
-> set sql_mode='ansi';
-> set @a=concat('haha','wawa');
-> end
-> //
Query OK, 0 rows affected (0.34 sec)mysql> call p4()//
Query OK, 0 rows affected (0.04 sec)mysql> select @a//
+----------+
| @a |
+----------+
| hahawawa |
+----------+
1 row in set (0.00 sec)
解决方案 »
- MySQL的一个简单问题,由于初学,所以不清楚了,麻烦大大们解答解答
- 为什么我的这个Navicat for MySQL连接不起呢??!!!!每次都出现2003-Can't connect to MySQL on 'localhost; (10061) 请哪位好心人告诉我答案好妈???
- 视图问题,同一个字段根据不同条件显示2次
- postgresql数据库创建函数总报错
- ALTER TABLE a ADD aId INT(10) UNSIGNED DEFAULT '-1' 为什么失败
- mysql中如何设置一个字段,表中每增加一个值,这个字段自动产生一个连续的序号?
- 请教关于sql_select的字句distinct的使用方法
- 求救!我的MySQL无法正常连接
- Mysql InnoDB故障
- 有两张表,从一张表对比另一张表找出缺少的记录,如何写这样的sql
- 怎么让mysql同时支持繁体和简体字???????
- mysql图形客户端问题
mysql>set @a='haha';
mysql>set @b='wawa';
mysql>set sql_mode='ansi';
mysql>set @c=@a || @b;返回的就是正确的
hahawawa这两者是不同的吗?
Query OK, 0 rows affected (0.00 sec)mysql> delimiter //
mysql> CREATE PROCEDURE `p4`()
-> BEGIN
-> set @a='haha' || 'wawa';
-> END
-> //
Query OK, 0 rows affected (0.06 sec)mysql> delimiter ;mysql> call p4();
Query OK, 0 rows affected (0.00 sec)mysql> select @a;
+----------+
| @a |
+----------+
| hahawawa |
+----------+
1 row in set (0.00 sec)mysql> set sql_mode='';
Query OK, 0 rows affected (0.00 sec)mysql> set @a='';
Query OK, 0 rows affected (0.00 sec)mysql> call p4();
Query OK, 0 rows affected (0.00 sec)mysql> select @a;
+----------+
| @a |
+----------+
| hahawawa |
+----------+
1 row in set (0.00 sec)mysql> show create procedure p4;
+-----------+-------------------------------------------------------------+-----
--------------------------------------------------------------------------------
--+
| Procedure | sql_mode | Crea
te Procedure
|
+-----------+-------------------------------------------------------------+-----
--------------------------------------------------------------------------------
--+
| p4 | REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI | CREA
TE DEFINER="root"@"localhost" PROCEDURE "p4"()
BEGIN
set @a='haha' || 'wawa';
END |
+-----------+-------------------------------------------------------------+-----
--------------------------------------------------------------------------------
--+
1 row in set (0.00 sec)