如何编辑巨大的SQL转储？

Question

I have a huge SQL-Dump with a lot of statements like

CREATE TABLE ...
INSERT INTO ...

and so on.

I want to edit this file. At first I want to delete all "CREATE TABLE" statements with all attributes. I only want the "INSERT INTO" statements. Is there an easy way? I'm a rookie at this area.

All "INSERT INTO" statements look like this:

INSERT INTO 'xyz' VALUES (a, b, c, d), (e, f, g, h), (c,d,e,g) ... 

I want to have it this way at the end:

INSERT INTO 'xyz' VALUES (<tenant_id>, a, b, c, d), (<tenant_id>, e, f, g, h), ...

Is there an easy way to realize that? E.g. with PHP or Regex? And how can I do this? Thank you!

Answer 1

If u have access any unix like system I recommend this:

sed '/CREATE TABLE */d' current.dump > new.dump

it will remove all the create table lines and pipe the rest to a new dump file