Mysql 按行dump出資料

標籤：

mysqldump -u${user} -p${passwd} --skip-extended-insert --database ${dbname} --table ${tablename} > ${tablename}.sql

用以上語句匯出的sql檔案中,每條資料都按照一個INSERT語句來儲存,方便用版本比較工具按行比較資料差異

例如

INSERT INTO `goods` VALUES (2,1049600,1,0,‘604800:88888:-1:-1:-1:-1:-1|‘,1464408000,1467019659,0,‘‘);INSERT INTO `goods` VALUES (4,1049600,1,0,‘604800:88888:-1:-1:-1:-1:-1|‘,1464408000,1467019659,0,‘‘);INSERT INTO `goods` VALUES (7,1049600,1,0,‘604800:88888:-1:-1:-1:-1:-1|‘,1464408000,1467019659,0,‘‘);INSERT INTO `goods` VALUES (8,1049600,1,0,‘604800:88888:-1:-1:-1:-1:-1|‘,1464408000,1467019659,0,‘‘);

 

Mysql 按行dump出資料