SELECT LENGTH("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',") AS tmplength;
-----88
SELECT LEFT("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',", 87) AS tmpsubstr;
--'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',本来我的目的是想去掉最后那个字符,结果还是不对,子字符串和源字符串("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',")
仍然是一模一样的。请问到底是怎么回事?
-----88
SELECT LEFT("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',", 87) AS tmpsubstr;
--'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',本来我的目的是想去掉最后那个字符,结果还是不对,子字符串和源字符串("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',")
仍然是一模一样的。请问到底是怎么回事?
解决方案 »
- Can't open shared library 'mysqlDll.dll'是什么问题?
- mysql数据库备份路径空格处理
- 连接同网络内其它机器上的My SQL失败 如何找寻解决办法?
- 用C#对mysql 数据库的更新操作问题,恳请各位高手帮助
- 我插入了几个相同的行, 怎样删掉其中一个呢?PHP怎样得到mysql的提示呢?
- 空指针异常
- 为什么用火车头采集不到gwwz.net的内容
- 怎么缩短连接mysql数据库耗时较多的问题?
- 新手求教:使用MAX后无法SQL报错
- 请问sqlserver里面怎么将字符串作为列名进行子查询?
- 修改表名的问题
- MYSQL在进行大表查询时报错ERROR CODE 28 C:盘空间不足了!
mysql> SELECT LEFT("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕
然','',", 87) AS tmpsubstr;
+----------------------------------------------------------------------------------------+
| tmpsubstr |
+----------------------------------------------------------------------------------------+
| 'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','', |
+----------------------------------------------------------------------------------------+
1 row in set (0.16 sec)
+----------------+
| length('毕然') |
+----------------+
| 6 |
+----------------+
1 row in setmysql> select left('毕然',2);
+----------------+
| left('毕然',2) |
+----------------+
| 毕然 |
+----------------+
1 row in set
mysql> SELECT LENGTH("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕然','',") AS tmplen
gth;
+-----------+
| tmplength |
+-----------+
| 86 |
+-----------+
1 row in set (0.00 sec)mysql> SELECT LEFT("'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕
"> 然','',", 87) AS tmpsubstr;
+-----------------------------------------------------------------------------------------+
| tmpsubstr |
+-----------------------------------------------------------------------------------------+
| 'U000000008','VICKY','96E79218965EB72C92A549DD5A330112','R000000002','6666','毕
然','', |
+-----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)