+ 2

how to delete a particular element

how to delete a element from a row.

13th Oct 2016, 11:27 AM
sahitya dubey
sahitya dubey - avatar
4 Réponses
+ 2
DELETE FROM table_name WHERE some_column=some_value;
13th Oct 2016, 11:33 AM
Zen
Zen - avatar
+ 1
DELETE FROM table_name WHERE id=<value _of_pk_column>; using id in where will ensure only 1 record is deleted and as it is indexed process will be faster. for new users it's better to use select query before deleting records, to avoid accidental deletion of records
16th Oct 2016, 8:40 PM
Anand Pol
Anand Pol - avatar
0
thanx buddy :-)
13th Oct 2016, 11:35 AM
sahitya dubey
sahitya dubey - avatar
- 1
DELETE column_name FROM table_name WHERE column_name = column_value This is right as well
14th Oct 2016, 5:50 PM
Dan Nemtanu
Dan Nemtanu - avatar