SQL Multiple inserts
Always forget this one at first but to do multiple inserts into a tabel you can use the following:
INSERT INTO tblName (name, age)
VALUES
('Andy', 26),
('Helen', 21),
('Justin', 23),
('Leighton', 25);
VALUES
('Andy', 26),
('Helen', 21),
('Justin', 23),
('Leighton', 25);
Comments
Does this work with MSAccess too?
Nice.. Didn't know that one!
Ryan, should work with Access though i've not got one setup currently to try
With MySQL, at least, you can also do INSERTS like an UPDATE statement. That is: INSERT INTO tblName SET name = 'Andy', age = '26'; Only get one insert per query that way, but it can be handy for large insert statements that are otherwise unreadable.
