传过来的参数 带有单引号 怎么办? 还是属于上次那个问题我现在是用左右%来like但穿过来的参数 本身中间就有‘这样就会打破 like的单引号范围,该怎么办?我是用kettle来做的,貌似里面的js步骤可以解决,但我不会............ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> create table tb(id int,name varchar(20) character set 'gbk');Query OK, 0 rows affected (0.05 sec)mysql> insert tb values(1,'liangck');Query OK, 1 row affected (0.00 sec)mysql> insert tb values(1,'liang''ck');Query OK, 1 row affected (0.00 sec)mysql> select * from tb;+------+----------+| id | name |+------+----------+| 1 | liangck || 1 | liang'ck |+------+----------+2 rows in set (0.00 sec)mysql> SET @param = _gbk'liang''c' collate gbk_bin;Query OK, 0 rows affected (0.00 sec)mysql> select @param;+---------+| @param |+---------+| liang'c |+---------+1 row in set (0.00 sec)mysql> select * from tb where name like concat(@param,'%');+------+----------+| id | name |+------+----------+| 1 | liang'ck |+------+----------+1 row in set (0.00 sec) 一般来说,都是先对参数预处理一下。比如你PHP/ASP输入的时候就把字符串中的 ' replace为 '' 用\转义、两个单引号、CHR(39) Linux下怎么让PDO支持mysql? 触发器问题 mysql-5.1.50-win32启动失败 mysql转换成excel 怎么实现如下循环语句? Select中使用子查询返回多个字段的问题 postgresql时间戳问题 删表内域的问题 新手!properties的内容如何写?请帮我改一下. 这种情况如何处理急啊,求大侠来看看 Mysql只有.FRM怎么恢复数据库? 求统计活跃用户数sql
Query OK, 0 rows affected (0.05 sec)mysql> insert tb values(1,'liangck');
Query OK, 1 row affected (0.00 sec)mysql> insert tb values(1,'liang''ck');
Query OK, 1 row affected (0.00 sec)mysql> select * from tb;
+------+----------+
| id | name |
+------+----------+
| 1 | liangck |
| 1 | liang'ck |
+------+----------+
2 rows in set (0.00 sec)mysql> SET @param = _gbk'liang''c' collate gbk_bin;
Query OK, 0 rows affected (0.00 sec)mysql> select @param;
+---------+
| @param |
+---------+
| liang'c |
+---------+
1 row in set (0.00 sec)mysql> select * from tb where name like concat(@param,'%');
+------+----------+
| id | name |
+------+----------+
| 1 | liang'ck |
+------+----------+
1 row in set (0.00 sec)