Nested insert queries in a single query

Expand Post »

hi ,
I have four different tables, all are linked together using foreign key relationships.
Now i need to insert data in to the tables.How can i use nested insert queries to insert data by a single query?

Similar Threads

SQL Queries help in Database Design
database connection(select ,insert query) within javascript function in JSP
Moving database to new server in MySQL
Insert Into in PHP
MySql multiple table query problem.... in MySQL

SubeeshBabu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2007

Permalink

Jul 15th, 2007

Re: Nested insert queries in a single query

Click to Expand / Collapse Quote originally posted by SubeeshBabu ...

hi ,
I have four different tables, all are linked together using foreign key relationships.
Now i need to insert data in to the tables.How can i use nested insert queries to insert data by a single query?

I suggest using transactions (you need the InnoDB storage engine for this).

SQL Syntax (Toggle Plain Text)
START TRANSACTION
  INSERT INTO blah...
  INSERT INTO blah...
COMMIT
start transaction
  insert into blah...
  insert into blah...
commit

If one of your statements causes an error none will be committed so you won't get corrupted data / missing keys etc.

pty

Reputation Points: 64

Solved Threads: 39

Posting Pro

Offline

530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: speed of insert into a MySQL db

Next Thread in MySQL Forum Timeline: Database and web design

DaniWeb Message

Cancel Changes

User Name
Password