[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