去国外流浪 3-6 个月？？？？

@hhhhhh123 希望 OP 采纳这个。 如果 OP 做完还能开源的话。那就太谢谢了，了却当时我毕设的心愿。 当初个人毕设是图书馆系统。

风格迁移。 拍个照 就能转换成二次元或者简化的图片。gan 算法

@raysonlu @Dlin @raysonlu @all 兄弟们，算了 不搞了。 谢谢各位的解惑。 反正 代码中测试 commit 是没有问题的 。

@raysonlu 这个是一样的
mysql> select pk_money from user_basic_info where uid= 123456803;
+----------+
| pk_money |
+----------+
| 500 |
+----------+
1 row in set (0.00 sec)

mysql> set autocommit=0; begin; SELECT pk_money FROM user_basic_info WHERE uid = 123456803 for update ; UPDATE user_basic_info set pk_money=pk_money+1 where uid =123456803;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

+----------+
| pk_money |
+----------+
| 500 |
+----------+
1 row in set (0.00 sec)

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select pk_money from user_basic_info where uid= 123456803;
+----------+
| pk_money |
+----------+
| 501 |
+----------+
1 row in set (0.00 sec)

mysql>

@Dlin mysql> select pk_money from user_basic_info where uid= 123456803;
+----------+
| pk_money |
+----------+
| 499 |
+----------+
1 row in set (0.00 sec)

mysql> begin; set autocommit=0; SELECT pk_money FROM user_basic_info WHERE uid = 123456803 for update ; UPDATE user_basic_info set pk_money=pk_money+1 where uid =123456803;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

+----------+
| pk_money |
+----------+
| 499 |
+----------+
1 row in set (0.00 sec)

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select pk_money from user_basic_info where uid= 123456803;
+----------+
| pk_money |
+----------+
| 500 |
+----------+
1 row in set (0.00 sec)

mysql>

@Dlin
你看看 我这语法有问题吗？ 应该是这样写的吧？

mysql> begin; set autocommit=0; SELECT pk_money FROM user_basic_info WHERE uid = 123456803 for update ; UPDATE user_basic_info set pk_money=pk_money+1 where uid =123456803;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

+----------+
| pk_money |
+----------+
| 498 |
+----------+
1 row in set (0.00 sec)

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select pk_money from user_basic_info where uid= 123456803;
+----------+
| pk_money |
+----------+
| 499 |
+----------+
1 row in set (0.00 sec)

mysql>

@zhanglintc 不一样 一个 2744 一个 2741

@zhanglintc 是啊，navicat 工具 不同的窗口

把个人博客啥的 搭在这个服务器 免费用。。

@raysonlu
session1 : SELECT pk_money FROM user_basic_info WHERE uid = 123456803; # pk_money= 496

session2:
```
BEGIN;
set autocommit=0;
select `pk_money` from user_basic_info where uid=123456803 for update ;
update user_basic_info set pk_money=pk_money+1 where uid=123456803;
# 这里没有 commit
```
结果
```
BEGIN
> OK
> Time: 0.047s


set autocommit=0
> OK
> Time: 0.045s


select `pk_money` from user_basic_info where uid=123456803 for update
> Affected rows: 0
> Time: 0.042s


update user_basic_info set pk_money=pk_money+1 where uid=123456803
> Affected rows: 1
> Time: 0.044s

```
再次运行 session1
session1 : SELECT pk_money FROM user_basic_info WHERE uid = 123456803; # pk_money= 497

@zhanglintc 主要是不会贴图片， 不然我就吧图片贴上来。 确确实实+1 。 不过代码就不会。 我也很好奇。 理论上确实不应该拿到未提交数据且更新到数据中了

@zhanglintc 因为网上的教程都是先 select 在 update 我以为这是必要流程

是 InnoDB

@rqxiao
@xhinliang
```
select @@transaction_isolation;
select @@global.transaction_isolation;
```
  结果是 REPEATABLE-READ

@xhinliang ``` show variables like '%tx_isolation%';``` 返回结果是空 啥也没有 ，这种是什么