MySQL存储过程详解

MySQL存储过程详解

MySQL存储过程:不区分大小写

mysmysql> select @AAa;
+-------+
| @AAa  |
+-------+
| AAAAA |
+-------+
1 row in set (0.00 sec)

mysql> select @AAA;
+-------+
| @AAA  |
+-------+
| AAAAA |
+-------+
1 row in set (0.00 sec)

mysql> select @aAA;
+-------+
| @aAA  |
+-------+
| AAAAA |
+-------+
1 row in set (0.00 sec)

mysql> create procedure Foo (INOUT s char(50)) select concat(s,",world");
Query OK, 0 rows affected (0.00 sec)

mysql> set @hello = "Hello";
Query OK, 0 rows affected (0.00 sec)

mysql> call Foo(@hello);
+--------------------+
| concat(s,",world") |
+--------------------+
| Hello,world        |
+--------------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> call fOO(@heLlO);
+--------------------+
| concat(s,",world") |
+--------------------+
| Hello,world        |
+--------------------+
1 row in set (0.00 sec)