Add/Update query - WebProWorld

WebProWorld

Part of WebProNews.com

		WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Add/Update query

Subscribe to the Newsletter FREE!

Mark Forums Read

Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here!

Reply

#1 (permalink)

Old

11-07-2006, 02:14 AM

mtomsana

mtomsana is offline

WebProWorld New Member

Join Date: Nov 2006

Location: Cape Town

Posts: 1

mtomsana RepRank 0

Default

Add/Update query

Hi everyone, i'm trying to create a query to transfer records from table to table and update records according to the changes made on the other table. The query must not duplicate records.

Reply With Quote

#2 (permalink)

Old

12-22-2006, 08:38 AM

linkstraffic linkstraffic is offline

linkstraffic is offline

WebProWorld Member

Join Date: Mar 2006

Posts: 56

linkstraffic RepRank 0

Default

you can try:

Code:

INSERT INTO ... SELECT ... ON DUPLICATE KEY UPDATE

http://dev.mysql.com/doc/refman/5.0/...rt-select.html

__________________
Website Traffic - Link Exchange - Job for Freelancers - Forum Casinos

Reply With Quote

Reply

Tags: addupdate, query

« House Plan Database Creation??? | A Good PostgreSQL GUI - Navicat »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Search Engine Friendly URLs by vBSEO 3.0.0