CSS font stacks & developer FAQs with Web standards
One of hundreds of answers available with our premium content service.
A: From a data management point of view, it does not seem necessary or sensible to make multiple inserts to a database with a single SQL statement. The nature of the INSERT statement is to create records, and records should be distinct from each other else they would be redundant and inefficient use of storage. An UPDATE statement on existing records can affect multiple records through a single statement, and that is more likely to be an appropriate way to manage your data. Having said that, a PreparedStatement that is used to iterate through a series of insert statements is a perfectly good way to add multiple different records to your database, as below.
… full answer hidden
Premium members click below for full answer
How can I insert multiple records at a time?