Merge 2 SQL insert queries -
ok not sure how explain here goes ...
i have database lets call foo 1 table has 3 rows row1,2,3 (row1 being id int auto) , have 2 insert sql queries need merge align:
insert `table` (`row2`) values ('value'); insert `table` (`row3`) values ('value');
1, possible? 2, if how?
update edit:
i know badly written said not sure how expain ..:( ok lets try again ...here basic structure export..
insert `bookmarks` (`id`, `name`, `url`) values (1, '', 'http://twitter.com'), (2, '', 'http://digg.com'), (3, '', 'http://stumbleupon.com'), (4, '', 'http://reddit.com'), continued further down...this lose url gain name (830, 'twitter', ''), (831, 'digg', ''), (832, 'stumbleupon', ''), (833, 'reddit', '');
i need add name row 1st part becomes
(4, 'reddit', 'http://reddit.com'),
i need bump rows/columns up
insert `table` (`row2`,`row3`) values ('val1','val2');
Comments
Post a Comment