AndyJarrett

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)
\n VALUES
\n ('Andy', 26),
\n ('Helen', 21),
\n ('Justin', 23),
\n ('Leighton', 25);
\n\n

\n

\n\n\n\n