mysql入门(二十)

1:update语句

 update  t_student set name='zhangs',email='[e-mail]' where no=3;
Query OK, 1 row affected (0.16 sec)
Rows matched: 1  Changed: 1  Warnings: 0

2：delete语句

 delete from t_student where no=3;
Query OK, 1 row affected (0.07 sec)

mysql> select * from t_student;
+------+----------+-------------+
| no   | name     | email       |
+------+----------+-------------+
|    1 | zhangsan | [e-mail] |
|    2 | lisi     | [e-mail] |
+------+----------+-------------+
2 rows in set (0.00 sec)