•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 425,954 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,629 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1483 | Replies: 4 | Solved
 |
•
•
Join Date: Oct 2007
Posts: 180
Reputation: 
Rep Power: 2
Solved Threads: 2
Junior Poster
Hi there
I'd like to know if it's possible to combine an update and insert query into one query. What I'd like to do is insert new data into one table and update a colum in another table at the same time.
For example, there are 3 different baskets (puppy basket, kitten basket and chick basket). I add a brown puppy to the puppy basket so I'd update the the basket table column that keeps track of the number of puppies in the puppy basket and insert into the puppy table the new puppy and it's colour.
Would I join the 2 queries with AND?
I'd like to know if it's possible to combine an update and insert query into one query. What I'd like to do is insert new data into one table and update a colum in another table at the same time.
For example, there are 3 different baskets (puppy basket, kitten basket and chick basket). I add a brown puppy to the puppy basket so I'd update the the basket table column that keeps track of the number of puppies in the puppy basket and insert into the puppy table the new puppy and it's colour.
Would I join the 2 queries with AND?
Last edited by Venom Rush : Feb 6th, 2008 at 3:26 am.
This user has a spatula. We don't know why, but we are afraid.
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
As far as I know, you can't have insert and update in the same query. The only case where you can have insert and update in the same query is when you use on duplicate clause . If you are using php to insert values to the table, you can do it without any problem.
Cheers,
Naveen
php Syntax (Toggle Plain Text)
Cheers,
Naveen
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Oct 2007
Posts: 180
Reputation:
Rep Power: 2
Solved Threads: 2
Junior Poster
Once again nav33n saves the day...thanks 
This user has a spatula. We don't know why, but we are afraid.
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
heh! yw ! Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Jul 2006
Location: Remunj
Posts: 207
Reputation:
Rep Power: 3
Solved Threads: 25
Posting Whiz in Training
INSERT INTO table (field) VALUES (value) ON DUPLICATE KEY UPDATE field=value
You need to specify keys to get this to work. See the mysql docs for more info. It is quite powerful and fast.
Last edited by peter_budo : Feb 13th, 2008 at 1:32 pm. Reason: Please use [code] tags to separate your DB query from rest of the post
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- JSTL compare string (JSP)
- Please help with JSP mysql update query (JSP)
- SQL Delete/Update Error (ColdFusion)
- help!! update mysql problem (MySQL)
- HTTP_REFERER and something else (PHP)
- download and upload (ASP.NET)
- Unable to insert form data into a database (ASP)
- need to update each records after record deleted (PHP)
- This ought to be simple - extra spaces (PHP)
Other Threads in the MySQL Forum
- Previous Thread: Populating a MySQL table with data from a csv file
- Next Thread: Where to get free MySQL?
