Multiple SQL statement in DataAssist
I have a case where an update needs to be done however lots of updates are being done depending on a number of conditions. For example, If # rooms needed = 3 then set rate = 100, If # room needed = 4 then set rate = 150, etc. I was planning on doing this with a number of set statements back to back but not sure I can add that custom code to the query that Data Assist sends. Does that seem like the best approach. I was also considering stored procedures but not sure if the new implementation in MySQL 5 allows for multiple statements in one sp.