| Title |
Test
Find
Split SQL INSERT Statement
|
| Expression |
(INSERT INTO\s+)(\w+)(\s+\()([\w+,?\s*]+)(\)\s+VALUES\s+\()(['?\w+'?,?\s*]+)(\)) |
| Description |
Use with "/i" flag (case-insensitive) to match a fully qualified SQL INSERT statement, and to parse it into it's component parts. Group $2 will contain the table name, $4 the field list, and $6 the value list. |
| Matches |
INSERT INTO table (field1, field2) VALUES (value1, value2) |
| Non-Matches |
INSERT INTO table VALUES (value1, value2) |
| Author |
Rating:
Not yet rated.
Benjamin Nelson
|
| Source |
TxITGuy |
| Your Rating |
|
