I am using
mysqldump to dump some records in a table:
mysqldump mydatabase mytable --where="field=value"
this emits script that includes
drop table mytable statement.
Since I use the
--where option, when I replay the script, I want to overwrite only these records that satisfy the condition
field=value. I want the emitted script to delete just these records:
delete from `mytable` where field=value
is there a way to achieve this?