eddydarell/Export SQL table data without ID primary key.md

Last active July 27, 2021 14:10

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/eddydarell/75ba977ce4aecb5a436d4e3e8283a39e.js"></script>
Save eddydarell/75ba977ce4aecb5a436d4e3e8283a39e to your computer and use it in GitHub Desktop.

Raw

Do a regular data dump with mysqldump or using a tool like MySQL Workbench and then run the command bellow to remove the primary key:

sed -i '' "s/([0-9]*,/(NULL,/gi" dump.sql

Useful when trying to appends data from an SQL export file of a table with the same structure.

Select an option