l3rodey Posted January 13, 2014 Share Posted January 13, 2014 I have been given a script, and it is a SQL script, I paid for it to be written but I asked for it to be in mySQL and now I am stuck with this junk... Can someone please help me convert this to mySQL as I don't know anything about mySQL update Users set Users.Point = Users.Points +3 WHERE Users.userID in (select userID from Tips inner join Games on Tips.GameID = Games.GameID and Games.Status = 2 and Games.calculated = 0) Please someone help me Quote Link to comment https://forums.phpfreaks.com/topic/285322-sql-to-mysql-help/ Share on other sites More sharing options...
gizmola Posted January 13, 2014 Share Posted January 13, 2014 I don't see any issue with that sql script. MySQL supports a number of different syntax options for things like joins, and that syntax appears to me to be valid. Quote Link to comment https://forums.phpfreaks.com/topic/285322-sql-to-mysql-help/#findComment-1465031 Share on other sites More sharing options...
Barand Posted January 13, 2014 Share Posted January 13, 2014 set Users.Point = Users.Points +3 Which is the correct column name, "point" or "points"? Quote Link to comment https://forums.phpfreaks.com/topic/285322-sql-to-mysql-help/#findComment-1465045 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.