LIMIT 1
#2

Means that it will only update the first row it finds. If your username column is set as unique, which it should be, then that condition is completely redundant. Same for select statements.
Reply


Messages In This Thread
LIMIT 1 - by Ugaustin - 11.06.2016, 10:53
Re: LIMIT 1 - by Vince - 11.06.2016, 10:56
Re: LIMIT 1 - by Ugaustin - 11.06.2016, 11:00
Re: LIMIT 1 - by SyS - 11.06.2016, 11:04
Re: LIMIT 1 - by Chilli9434 - 11.06.2016, 11:08
Re: LIMIT 1 - by Ugaustin - 11.06.2016, 11:13
Re: LIMIT 1 - by d1git - 11.06.2016, 11:22
Re: LIMIT 1 - by Stinged - 11.06.2016, 11:22

Forum Jump:


Users browsing this thread: 1 Guest(s)