How to remove a row on mysql? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

How to remove a row on mysql?

10th Mar 2018, 1:55 PM
Dinith Sadeepa
Dinith Sadeepa - avatar
3 Answers
10th Mar 2018, 3:58 PM
Gaurav Agrawal
Gaurav Agrawal - avatar
+ 8
Use DELETE command; DELETE FROM table_name WHERE specific_condition; Mind you if you don't specify a condition you will delete all records. Hth, cmiiw
10th Mar 2018, 2:08 PM
Ipang
+ 2
DELETE FROM users WHERE id = 1;   You are deleting the user who has id=1.
10th Mar 2018, 2:07 PM
Walef
Walef - avatar