Skip to content

Instantly share code, notes, and snippets.

@yangyang5214

yangyang5214/mysqldump.md

Created April 10, 2023 07:14
Show Gist options
  • Save yangyang5214/35151f088e8c4be50d513cc146863846 to your computer and use it in GitHub Desktop.
Save yangyang5214/35151f088e8c4be50d513cc146863846 to your computer and use it in GitHub Desktop.
Download ZIP
mysqldump
Raw
mysqldump.md

demo

mysqldump --complete-insert --opt db_name table_name | grep 'INSERT INTO `table_name`' > result.sql
  • --complete-insert 包含列名。用于不同版本间 sql 同步
  • --opt db_name table_name。指定 db table
  • grep。只保留 insert into 语句
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment