10.02.2011, 23:37
I was working on another accounting system with MySQL when I thought to myself; "What is a better method of saving this?". I am thinking of two different ways...
One: You perform multiple queries, using "UPDATE `accounts` SET ..." as the beginning of each query and send them to the SQL server.
Two: You format multiple strings and send all of the data via one query.
I do not have examples to show right now, but I will provide some if necessary...
One: You perform multiple queries, using "UPDATE `accounts` SET ..." as the beginning of each query and send them to the SQL server.
Two: You format multiple strings and send all of the data via one query.
I do not have examples to show right now, but I will provide some if necessary...