MYSQL Update

leewad

Im using the following to update databases

MYSQL_QUERY( "insert into $table1 SELECT * FROM $table2 where 1 ");

There are 24 fields in each table, my problem is if a reference number ( ie. R12121 ) exists in table1 i want it to update and not add new record, how can this be done?

bradgrafelman

Is there a UNIQUE or a PRIMARY KEY index on this field? If so, you'll want to use MySQL's INSERT ... ON DUPLICATE KEY UPDATE Syntax. (And if not, why not?)

Perhaps an even better question might be: Why are you duplicating data in your database like this in the first place?

leewad

Yes there is a primary key set, i get updates in a XML and they used to be new additions now they have added updates in the XML it is a property site so any new properties on the market got added but now if there is a price change etc then this also get added to the feed so i need to replace existing recorded ( identified by a reference number ) and not add a duplicate entry

Weedpacket

leewad wrote:
so i need to replace existing recorded ( identified by a reference number ) and not add a duplicate entry

In that case, your reasoning at this point would be:

bradgrafelman wrote:
Is there a UNIQUE or a PRIMARY KEY index on this field?

leewad wrote:
Yes there is a primary key set,

bradgrafelman wrote:
If so, you'll want to use ....

dalecosp

news.cnet.com wrote:
Programmer invents new imperative scripting language

Weedpacket, an outstanding member of the PHP community-at-large and moderator of the forums at PhpBuilder.com, today invented a new imperative scripting language called Quote. Quote uses snippets of forum posts to create a logical, team-written syntax for collaboration-based functional programming.

Observers have heralded this development as a new milestone in the quest for a self-aware semantic web-based artificial intelligence....

😃

Weedpacket

dalecosp wrote:
Observers have heralded this development as a new milestone in the quest for a self-aware semantic web-based artificial intelligence....

Weedpacket wrote:
...that syngergistically leverages core competencies to enhance outcome engagement.

I think I know what that means, too. Weep for me.

traq

dalescop wrote:
Observers have heralded this development as a new milestone in the quest for a self-aware semantic web-based artificial intelligence

Weedpacket wrote:
that syngergistically leverages core competencies to enhance outcome engagement.

constructive.

the only drawback (feature?) is that you can't use a Quote script without adding at least two characters to the code (otherwise, the compiler gives the error, "The message you have entered is too short. Please lengthen your message to at least 2 characters.").