mostwanted
05-03-2008, 12:09 PM
Ok... I don't know what I am doing as I have never done this before...
What I am needing done is this..
I need to copy a certain field from one database to another field in a different database...
Here is an example of what I need to know how to do...
INSERT INTO `images` (`id`, `type`, `folder`, `url`, `code`) VALUES (7712, 'Adult', 'BBW', 'http://link to image', ''),
(3089, 'Sad/Sorry', 'All', 'http://link to image', ''),
notice the link to image.. I need this copied over or merged over into another database table into the following....
INSERT INTO `graphics` (`CCat`, `OCat`, `CName`, `OName`, `VoteHash`, `Added`, `thumb`, `views`, `tags`, `user`, `pending`, `totalvote`, `votes`, `rwidth`) VALUES ('Compliments', 'Compliments', 'Thank you', 'Thank-you-2008-04-16.gif', '1bdfeb', '2008-04-20 14:13:43', 'http://Link to Image', 3, 'thank you, purple, flowersthank you, purple, flowers, ', '', '', 0, 0, 0.00),
('Holiday', 'Holiday', 'Cinco', 'Cinco-2008-05-03.gif', 'd27fc1', '2008-05-03 09:29:22', 'http://Link to Image', 0, 'cinco, ', '', '', 0, 0, 0.00);
I am not worried about the extra tables except the categories of where the images are... I need those transfered as well...
If anyone could please explain to me what I need to do to accomplish this I would be forever grateful!
I would hate to manually transfer over 8,000+ images over manually...:eek:
What I am needing done is this..
I need to copy a certain field from one database to another field in a different database...
Here is an example of what I need to know how to do...
INSERT INTO `images` (`id`, `type`, `folder`, `url`, `code`) VALUES (7712, 'Adult', 'BBW', 'http://link to image', ''),
(3089, 'Sad/Sorry', 'All', 'http://link to image', ''),
notice the link to image.. I need this copied over or merged over into another database table into the following....
INSERT INTO `graphics` (`CCat`, `OCat`, `CName`, `OName`, `VoteHash`, `Added`, `thumb`, `views`, `tags`, `user`, `pending`, `totalvote`, `votes`, `rwidth`) VALUES ('Compliments', 'Compliments', 'Thank you', 'Thank-you-2008-04-16.gif', '1bdfeb', '2008-04-20 14:13:43', 'http://Link to Image', 3, 'thank you, purple, flowersthank you, purple, flowers, ', '', '', 0, 0, 0.00),
('Holiday', 'Holiday', 'Cinco', 'Cinco-2008-05-03.gif', 'd27fc1', '2008-05-03 09:29:22', 'http://Link to Image', 0, 'cinco, ', '', '', 0, 0, 0.00);
I am not worried about the extra tables except the categories of where the images are... I need those transfered as well...
If anyone could please explain to me what I need to do to accomplish this I would be forever grateful!
I would hate to manually transfer over 8,000+ images over manually...:eek: