The delete command
mysql 4.1.16-nt-max> delete from
table01 where field01=3;
Query OK, 1 row affected (0.01 sec)
mysql 4.1.16-nt-max> select * from table01;
| field01 |
field02 |
field03 |
field04 |
field05 |
| 1 |
first |
new info |
1999-10-22 |
15:29:01 |
| 2 |
second |
another |
1999-10-23 |
15:29:01 |
|