[Micko123]

Okay so I am new at MySQL and I am following one tutorial for log/reg sys.
I found this

PHP код:

UPDATE `players` SET `deaths` = %d WHERE `id` = %d LIMIT 1 


I understand most of this but what I don't understand is this

PHP код:

WHERE `id` = %d LIMIT 1 


Can someone explain me this limit 1??

Thx in advance

[AjaxM]

It means that we need only 1 result to be shown.

[justice96]

As once it's found one result, it'll stops.

[Micko123]

Thanks guys

[Vince]

It's pretty useless in this case since - assuming that "id" is the primary key - there will always be only one result anyway.

[Micko123]

Quote:

Originally Posted by Vince It's pretty useless in this case since - assuming that "id" is the primary key - there will always be only one result anyway.

Yeah but you'll never know xD

[Vince]

Um yeah, you do know. That's the point of the primary key: being unique in the table. It's impossible to insert a duplicate key; MySQL simply won't let you.