mysql multiple vs single
Posted: Wed Mar 01, 2006 5:00 am
I often need to insert multiple records into tables. I wonder if there is much of a difference (performance-wise) to use
instead of
?
Code: Select all
INSERT INTO users VALUES (1, 'John', 'Smith', 'UK', 32),
(2, 'Fabrizio', 'Macaroni', 'IT', 28),
(3, 'Ronald', 'McDonald', 'US', 100)Code: Select all
INSERT INTO users VALUES (1, 'John', 'Smith', 'UK', 32)
INSERT INTO users VALUES (2, 'Fabrizio', 'Macaroni', 'IT', 28)
INSERT INTO users VALUES (3, 'Ronald', 'McDonald', 'US', 100)