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)