11138

echo str_replace(["%3A", "%2F", "%40"], [":", "/", "@"], rawurlencode('http://www.test.com/u/1/2/中国 english 123 -.jpg'));

KEY `emp_no` (`emp_no`)
这个是多余的，用 explain 分析一下就清楚了。 @lcorange @wwqgtxx

https://dev.mysql.com/doc/refman/5.7/en/commit.html
START TRANSACTION or BEGIN start a new transaction.

mysql> use employees;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * from employees where emp_no=10002;
+----+--------+
| id | emp_no |
+----+--------+
| 1 | 10002 |
+----+--------+
1 row in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> use employees;set autocommit=0;begin;SELECT * from employees where emp_no=10002;commit;
Database changed
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

+----+--------+
| id | emp_no |
+----+--------+
| 1 | 10002 |
+----+--------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

语法没有问题，问题在于你的用法有问题，你应该帖出相关的使用代码。

@iVanilla 设置 precision 影响显示的值的位数（整数部分和小数点部分），但是开始和结尾部分的 0 不算数。
<?php
$num = 0.012345600000000000;
ini_set("precision", "12");
echo $num; // 0.0123456
echo "\n";
ini_set("precision", "3");
echo $num; // 0.0123
echo "\n";
ini_set("precision", "5");
echo $num; // 0.012346
echo "\n";
?>

@iVanilla 是的，这个 precision 默认值在 php.ini 里。

@iVanilla
<?php
$a = 1.002;
$a -= 1.001;
echo $a;
?>