MySQL Syntax Error
#5

Is LIMIT even a valid keyword in an update statement? The fact that you need it makes me think that your tables aren't properly indexed. A username should be unique so there should not be any need to use LIMIT at all. Plus, using the players name as a key is a bad idea. Research primary keys.
Reply


Messages In This Thread
MySQL Syntax Error - by venomlivno8 - 13.01.2016, 16:12
Re: MySQL Syntax Error - by PrO.GameR - 13.01.2016, 16:56
Re: MySQL Syntax Error - by valych - 13.01.2016, 21:43
Re: MySQL Syntax Error - by PrO.GameR - 14.01.2016, 09:08
Re: MySQL Syntax Error - by Vince - 14.01.2016, 09:35
Re: MySQL Syntax Error - by valych - 14.01.2016, 09:39
Re: MySQL Syntax Error - by venomlivno8 - 14.01.2016, 21:57

Forum Jump:


Users browsing this thread: 1 Guest(s)