HuyPV
Friday, November 16, 2012
mysqldump
--complete-insert # column name
--compact
--no-create-info # no create table
--skip-extended-insert # insert per row
--insert-ignore # insert ignore into
-uroot -plov30nn DB_NAME TABLE_NAME
--where="id > 2010"
> C:\insert.sql
mysqldump --complete-insert --compact --no-create-info --skip-extended-insert --insert-ignore -uroot -plov30nn shop products --where="id > 2102" > C:\insert.sql
Title:
mysqldump insert ignore where
Description:
mysqldump --complete-insert # column name --compact --no-create-info # no create table --skip-extended-insert # insert per row --insert...
...
Rating:
4