Andy Jarrett //
Code. Develop. Manage.
Dismiss
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
I’m here, learning and working away. If you liked this content and want to keep me going, consider
buying me a coffee
.
Your support keeps this site running and the coffee brewing! ☕️