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

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -