Regular Expressions 101

insert into (a,b,c) values (1,2.3,"test");

but it does not work. How do I make it work? It will be used in C#

Matches european dates (DD.MM.YYYY[ HH:MM:SS]) and MS-SQL Timestamp ({ts 'YYYY-MM-DD HH:MM:SS'})

13 fields, 12 comma's from right (all left hand ones need to be ignored as they're part of the sql statements)

insert[\s]+into[\s]+\([\s](?.?)[\s]\)[\s]+values[\s]+\((?.?)[\s]*\);

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);

A regex to find the db wich you're quering against to.

matching any SQL query starting by "SELECT foo,bar FROM fool,baz {...}" this one is the good one. first one have a matching alowing * in the FROM statement.

SQL LIMIT REMOVE