Password resets to "NoPassword" in MySQL
#7

Quote:
Originally Posted by Eoussama
Посмотреть сообщение
Why are you update their name?
My thoughts exactly.

KizZweLL, you should understand the concept of SQL. You update only those values that change.

The reason why it failed is probably not enough string size to hold the entire query.

Also using the player's name in WHERE clause in every query is slower (excluding the first query to determinate if account exists). Each player must have a unique ID (auto increment) and you identify the player by that value. Integer comparison is always faster than string comparison.
Reply


Messages In This Thread
Password resets to "NoPassword" in MySQL - by KizZweLL - 21.06.2017, 12:57
Re: Password resets to "NoPassword" in MySQL - by JasonRiggs - 21.06.2017, 12:58
Re: Password resets to "NoPassword" in MySQL - by Konstantinos - 21.06.2017, 13:01
Re: Password resets to "NoPassword" in MySQL - by KizZweLL - 21.06.2017, 13:15
Re: Password resets to "NoPassword" in MySQL - by JasonRiggs - 21.06.2017, 13:31
Re: Password resets to "NoPassword" in MySQL - by Eoussama - 21.06.2017, 13:36
Re: Password resets to "NoPassword" in MySQL - by Konstantinos - 21.06.2017, 13:45

Forum Jump:


Users browsing this thread: 2 Guest(s)