devxlogo

SQL Adding Records

SQL Adding Records

Question:
What is the syntax for inserting multiple records into a single query. I have some files with thousands of records to insert and it’s too slow using Insert into x VALUES (a,b,c).

What I want to do is something likeINSERT INTO x VALUES((a,b,c),(d,e,f)…As many as I can in one hit. I am using access as the DBMS and VB as the programming paradigm.

Answer:
Depending on where you are inserting from (I’m guessing tables) you might try INSERT SELECT.

From BOL;INSERT author_sales    SELECT 'SELECT', authors.au_id, authors.au_lname,         SUM(titles.price * sales.qty)     FROM authors INNER JOIN titleauthor         ON authors.au_id = titleauthor.au_id INNER JOIN titles        ON titleauthor.title_id = titles.title_id INNER JOIN sales        ON titles.title_id = sales.title_id    WHERE authors.au_id LIKE '8%'    GROUP BY authors.au_id, authors.au_lname

See also  Why ChatGPT Is So Important Today
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist