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'),

enter image description here

i need bump rows/columns up

insert `table` (`row2`,`row3`) values ('val1','val2'); 

Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -