I have an update query that I'm trying to implement. It just won't work. (It's not exactly the query below but I'm just trying that in order to try and get a simple query to work)
So, I'm trying to update the column Password below. Doesn't work. However, if I try and update the column Team (simply substitute Password for Team) and it works fine. So, everything is fine except that the column Password just won't update (the error message is that there is an error in the syntax of the sql query... which can't be since the column Team works just fine)
So, I've looked at the columns and I can't see any reason why this would be happening. Just to be on the safe side I filled the password with the same info as in the team column and set all the properties of the password column to the same as the team column... still doesn't work?
MySQL = "UPDATE `User Information`"
MySQL = MySQL + " SET Password = NULL"