mysql简单语句

1.修改表中的某一数据，语句为：update 表名 set 表中的字段=修改的数据 where 具体位置;
eg.
mysql> select * from wan;
+------+------+
| id   | name |
+------+------+
|    1 | john |
|    2 | jack |
+------+------+
2 rows in set (0.00 sec)

mysql> update wan set name='mike' where id=2;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from wan;
+------+------+
| id   | name |
+------+------+
|    1 | john |
|    2 | mike |
+------+------+
2 rows in set (0.00 sec)

mysql> update wan set name='jack';
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> select * from wan;
+------+------+
| id   | name |
+------+------+
|    1 | jack |
|    2 | jack |
+------+------+
2 rows in set (0.00 sec)