请看看，谢谢

[chenhaohh]

mysql> select *from TBbook1;

|number|name|money| left |
+--------+------+---------+--------+
| 3 | cc | 12 | 9 |
| 4 | dd | 30 | 10 |
+--------+------+---------+--------+
请问：使用命令把left这一列的数字－1，该怎么写阿？
谢谢！

[晨星]

select number, name, money, left - 1 from TBbook1;

[chenhaohh]

[Quote=引用 1 楼 steedhorse 的回复:]
select number, name, money, left - 1 from TBbook1;

[/Quote]
谢谢
还想问下：如果是只把number=3怒明白的这一行的left数字-1，怎么写呢？

[steptodream]

select number, name, money, left - 1 from TBbook1 where number=3;

[once_and_again]

学习..