I am currently writing a series of scripts to handle a quiz. As usual when i write these things I try and implement little things that I may have not known about before, or that I have never had a chance to use.
When doing and ‘Insert’ query, you can do multiple inserts. Why isn’t it the same for ‘Update’? It would make life a lot easier.
Note to self: when trying to update multiple rows remember to include the relevant identifier otherwise the script won’t know what to update and throw a tantrum.