mysql - how to delete a single row from database -
i need delete single row table. when run query deletes row. can can me on this? here code below :
delete table_name
delete table_name limit 1
here's basic syntax of delete
in mysql
delete [low_priority] [quick] [ignore] tbl_name [where where_condition] [order ...] [limit row_count]
or can specific id
delete table_name id = 'x' limit 1
if don't specify limit
, delete records matches condition.
but there exception, can omit limit
if filtering via unique
column.
Comments
Post a Comment