regex101: JavaScript Substitution Workspace

Group 1((CREATE.*my_table.*\n)|(\s+.*tinyint.*\n)|(\s+.*(?!tinyint)\n))

1st Alternative(CREATE.*my_table.*\n)

Group 2(CREATE.*my_table.*\n)

CREATEthe literal text CREATE (case sensitive)

.*any character (except for line terminators), repeated any number of times

my_tablethe literal text my_table (case sensitive)

.*any character (except for line terminators), repeated any number of times

\na line-feed (newline) character (ASCII 10)

2nd Alternative(\s+.*tinyint.*\n)

Group 3(\s+.*tinyint.*\n)

\s+any whitespace character, repeated at least once

.*any character (except for line terminators), repeated any number of times

tinyintthe literal text tinyint (case sensitive)

.*any character (except for line terminators), repeated any number of times

\na line-feed (newline) character (ASCII 10)

3rd Alternative(\s+.*(?!tinyint)\n)

Group 4(\s+.*(?!tinyint)\n)

\s+any whitespace character, repeated at least once

.*any character (except for line terminators), repeated any number of times

Negative Lookahead(?!tinyint)

tinyintthe literal text tinyint (case sensitive)

\na line-feed (newline) character (ASCII 10)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

26 tokens

Regular Expression

((CREATE.*my_table.*\n)|(\s+.*tinyint.*\n)|(\s+.*(?!tinyint)\n))

New

CREATE TABLE `my_table` (
  `id` bigint(20) NOT NULL,
  `id2` bigint(27) NULL,
  `REVTYPE` tinyint(4) DEFAULT NULL,
  `REVTYPE2` bigint(52) blahblah,
  `REVTYPE` tinyint(7) stuff
  `some_other_column` varchar(255)
);

Substitution

$2$3

CREATE TABLE `my_table` (
  `id` bigint(20) NOT NULL,
  `id2` bigint(27) NULL,
  `REVTYPE` tinyint(4) DEFAULT NULL,
  `REVTYPE2` bigint(52) blahblah,
  `REVTYPE` tinyint(7) stuff
  `some_other_column` varchar(255)
);