08.11.2018, 11:20
Quote:
I am sorry to say but I see no 'many changes'. You only fixed the unknown columns in line 216, everything else remained the same:
- no escaping input - not deleting cache in one place - no affected rows = success message anyway - no index Changing LIMIT 10 to LIMIT 100 does not change anything. You do not need LIMIT in the first place, just GROUP BY `S.No` and remove WHERE clause as well. You also removed global option DUPLICATE_CONNECTIONS for no reason. Now any gamemode connecting to the same database and server will result in warning in mysql logs. |
and i wanna talk about index and affected rows.
What are the problems in them?
Thanks