Skip to content

Instantly share code, notes, and snippets.

@ylacancellera

ylacancellera/mysql_ddl_from_cmd_outputs

Created December 8, 2022 09:56
Show Gist options
  • Save ylacancellera/f4443ef04cfb8c9f30a496b4e1d6544f to your computer and use it in GitHub Desktop.
Save ylacancellera/f4443ef04cfb8c9f30a496b4e1d6544f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_ddl_from_cmd_outputs
grep -oPz "CREATE TABLE \`.*\` \(\n(.*\`.*\`.*\n)*\) ENGINE=.*\n" output.txt | sed -Ee 's/^\).*[^(),]$/\0;/' > ddl.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment