sql2json does not support INSERT INTO ... VALUES(a,b), (c,d) syntax #11
Description
This came up on StackOverflow.
The following syntax for sql2jaon works well and shows both inserted rows:
CREATE TABLE `geo_tags` (
`gt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gt_page_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`gt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4507036 DEFAULT CHARSET=binary ROW_FORMAT=DYNAMIC;
INSERT INTO `geo_tags` VALUES (3,487781);
INSERT INTO `geo_tags` VALUES (4,487781);
But using a shorter syntax for the INSERT, which is usually used by mysqldump, would only show the first value:
CREATE TABLE `geo_tags` (
`gt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gt_page_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`gt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4507036 DEFAULT CHARSET=binary ROW_FORMAT=DYNAMIC;
INSERT INTO `geo_tags` VALUES (3,487781), (4,487781);