
Jerry Seeger - 2014-12-16 21:52:34
insert statement like
INSERT INTO `my_table` (`id`, `name`)
VALUES
(2,'name with ; in it'),
(55,'name')
will not parse correctly. The line with the ; will be treated as the last line of the query because it matches
preg_match("/(.*);/", $sql_line)
I changed the above to
preg_match("/(.*);^/", $sql_line)
Not sure if that will break something else, as it assumes semicolons to end sql statements are at the ends of lines, but it got me past my immediate hurdle.