+ 2
how to delete a particular element
how to delete a element from a row.
4 Respuestas
+ 2
DELETE FROM table_name WHERE some_column=some_value;
+ 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
0
thanx buddy :-)
- 1
DELETE column_name
FROM table_name
WHERE column_name = column_value
This is right as well