Community Learn Tools Library Leisure
search
English

Delete Record

Use delete to delete records


QQ截图20161009162523.png


##user table, the table structure is as follows:


QQ截图20161009162532.png


##mysql> delete from user where id = 1;

Query OK, 1 row affected (0.08 sec)


Delete the record of the row with ID 1, Li Wenkai.

Clear table records

delete and truncate are the same, but they have one difference, that is, DELETE can return the number of deleted records, while TRUNCATE TABLE returns 0.

If there is an auto-increment field in a table, use truncate table to restore the starting value to 1.


QQ截图20161009162540.png

QQ截图20161009162544.png


#【Remember】

1. When deleting, be sure to remember to add the where condition, otherwise the records in the entire table will be cleared.

2. Be sure to back up, back up, back up before deleting important data.

Continuing Learning
||
<?php echo "Hello Mysql"; ?>
submitReset Code
Previous section Next Section
Tutorial List
get help
  • Course Recommendations
  • Courseware download
The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~

Students who have watched this course are also learning

The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)  492962 plays