Regular Expressions 101

Community Patterns

sql: insert into

1

Regular Expression
PCRE (PHP <7.3)

/
insert[\s]+into[\s]+(?<table>.*?)[\s]*\([\s]*(?<columns>.*?)[\s]*\)[\s]+values[\s]+\((?<values>.*?)[\s]*\);
/
gmi

Description

insert into table ( a, b, c ) values ( " insert into values (1,2,3)",1,2.3,"a,b" );

insert into table (ee,bb,cc) values (aa,234,"asj",2.3);

Submitted by suat erenler - sua.gen.tr - 9 years ago