[Baboon]

When should I use LIMIT 1 in mysql?

Thanks.

[dice7]

when you only want one result, usualy when getting the biggest/smallest value or something

[Baboon]

Okay, thanks, do you also know how to delete an user, which is stored in a table?

[TheArcher]

The syntax for that is

Код:

 DELETE FROM "table_name" WHERE {condition}

[TTJJ]

I would strongly recommend putting "LIMIT 1" at the end of that statement. (If you only want to delete 1 row) I have deleted multiple rows by accident sometimes. Really annoying.