直接加就可以了呀：mysql> select "123";+---+ | 123 | +---+ | 123 | +---+ 1 row in set (0.00 sec)mysql> select "123" + 1;+---+ | "123" + 1 | +---+ | 124 | +---+ 1 row in set (0.00 sec)...
mysql 怎样把字符串转化为数字再+1
直接加就可以了呀：
mysql> select "123";
+-----+
| 123 |
+-----+
| 123 |
+-----+
1 row in set (0.00 sec)
mysql> select "123" + 1;
+-----------+
| "123" + 1 |
+-----------+
| 124 |
+-----------+
1 row in set (0.00 sec)2014-01-21
sql这样写 ： 字段*1+12014-01-21
atoi(col)+12014-01-21
