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);
| Tweet |
Comments (0) | 
Print |
Send |
16749 Views
| If you like what you see on the website and/or this post has helped you out in some way please consider donating to help keep me in beer vodka. The donations are made through Paypal, which accepts almost any credit card or eCheck. |