[Bristolbathpm] Mysqldump restoring and updating
psykx.out
psykx.out at googlemail.com
Fri Jul 11 07:36:44 BST 2008
Lyle wrote:
> psykx.out wrote:
>
>> I'm not I understand perfectly, you can use 'replace into' instead of
>> 'insert into' if you want to overwrite (edit) existing data. replace
>> acts like insert if the is no existing record
>>
>
> Thing is I don't want to replace, I want to merge...
>
>
> Lyle
> _______________________________________________
> BristolBathPM mailing list
> BristolBathPM at bristolbath.org
> http://mailman.bristolbath.org/mailman/listinfo/bristolbathpm
>
Ah the beauty of replace, if you don't set all the fields in the table
and it replaces another row it just leaves the old data there.
Max
More information about the BristolBathPM
mailing list