INSERT INTO (Multiple-record append query/Insert multiple records)

INSERT INTO (Multiple-record append query/Insert multiple records)

Post by Michael Gr » Sun, 23 Nov 2008 08:02:40


In article <b30a2278-d696-4f99-8bf5-9754110c7b03
@x8g2000yqk.googlegroups.com>, XXXX@XXXXX.COM says...
What book are you learning from? SQL that might work for SQL Server
2008 will not work in Access.

Why not just download the free SQL Server Express 2008 onto you PC and
try running your insert there? Then you can use Access for forms and
reports and also use all the latest SQL features of SQL Server.
 
 
 

1. Newbie-- sp with multiple record insert: how to get all inserted identities

2. Insert Multiple Records Using One Insert Statemen with MySQLdb module

Hi,

I'd like to insert Multiple Records Using One Insert Statement

inserting one record using one insert statement works
this is the example:

import MySQLdb
conn = MySQLdb.connect(host="localhost",.....)
cursore = conn.cursor()
cursore.execute('INSERT INTO frutta (nome, quantita) VALUES(%s, %s)',
('Pompelmi', 10)
)

but when I try to insert Multiple Records Using One Insert Statement
in this way:

cursore.execute('INSERT INTO frutta (nome, quantita) VALUES(%s, %s)',
('Pompelmi', 10),
('Pompelmi', 10),
('Pompelmi', 10)
)

it doesn't work!

Antonella

3. How to check record exists before INSERT multiple records

4. Append multiple records from a single record

5. How to write a SQL query that inserts a record for every record in

6. problem w/CREATE RULE...ON INSERT...INSERT INTO...SELECT...FROM...WHERE w/multiple inserts

7. Replace one multiple quantity record with multiple records

8. Update existing record else insert record if no record exists

9. Multiple MX records or multiple A records?

10. Using an Append Query to add multiple records to a table

11. create append query resulting in multiple new records

12. Append query - was: Query for records with no matching records in another table?

13. Append/Update Query to add multiple records to Table?

14. Multiple Records Generated from Append Query

15. Append Query writing multiple records.