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 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. 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 Quote set Users.Point = Users.Points +3 Which is the correct column name, "point" or "points"? Link to comment https://forums.phpfreaks.com/topic/285322-sql-to-mysql-help/#findComment-1465045 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.