Skip to content

Instantly share code, notes, and snippets.

@ttj4
Created May 14, 2020 11:05
Show Gist options
  • Save ttj4/0a4bac3cd4fa120a09a523b851aec593 to your computer and use it in GitHub Desktop.
Save ttj4/0a4bac3cd4fa120a09a523b851aec593 to your computer and use it in GitHub Desktop.
remove primary key in mysql dump
mysqldump command with db +/- table | sed -e "s/([0-9]*,/(NULL,/g" > 1.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment