Solved

MySQL - I need to duplicate a record in same table, but alter some fields?

Posted on 2014-04-07
2
387 Views
Last Modified: 2014-04-08
MySQL - I need to duplicate a record in same table, but alter some fields?

Is there a way to duplicate say record 782 and alter the value of `image1` ,`image2` ,`image3` ,`image4` & `image5` WHERE none of these fields contain nopic.jpg?

If I was duplicating the record with id 782, I need the new value of `image1` column to be equal to  "/uploads/item1063_1_copy.jpg"?

Thanks in advance for your feedback.

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL auto_increment,
  `item_type` enum('G','S','F') default 'F',
  `min_order` tinyint(3) default '1',
  `prodcode` varchar(10) default NULL,
  `true_stock_count` varchar(200) default '0',
  `display_stock_count` varchar(200) default '0',
  `low_stock_count` varchar(40) default '0',
  `date_time_expires` varchar(120) default NULL,
  `limit_availability` varchar(20) default NULL,
  `itemName` varchar(50) default NULL,
  `itemDesc` text,
  `itemDesc2` text,
  `itemDesc3` text,
  `weight` decimal(12,2) NOT NULL default '0.00',
  `height` mediumint(8) NOT NULL,
  `length` mediumint(8) NOT NULL,
  `width` mediumint(8) NOT NULL,
  `combined_postage` int(3) default '1',
  `item_postage` varchar(120) default NULL,
  `item_postage_amt` double(4,2) default NULL,
  `aust_post_estimate` varchar(240) default 'Regular Parcel - $6.60    Express Post - $9.55',
  `tabs_needed` tinyint(3) default '0',
  `tabhead1` varchar(60) default 'Description',
  `tabhead2` varchar(60) default NULL,
  `tabhead3` varchar(60) default NULL,
  `itemDescb` varchar(40) default NULL,
  `itemPrice` decimal(8,2) default '0.00',
  `retPrice` decimal(8,2) default '0.00',
  `specialPrice` decimal(8,2) default '0.00',
  `specs1` varchar(180) default NULL,
  `spechead1` varchar(180) default NULL,
  `specs2` varchar(180) default NULL,
  `spechead2` varchar(180) NOT NULL,
  `add_comments` char(1) default 'N',
  `more_details` enum('Y','N') default 'N',
  `image1` varchar(60) default '/uploads/nopic.jpg',
  `image2` varchar(60) default '/uploads/nopic.jpg',
  `image3` varchar(60) default '/uploads/nopic.jpg',
  `image4` varchar(60) default '/uploads/nopic.jpg',
  `image5` varchar(60) default '/uploads/nopic.jpg',
  `cookie` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1062 ;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `item_type`, `min_order`, `prodcode`, `true_stock_count`, `display_stock_count`, `low_stock_count`, `date_time_expires`, `limit_availability`, `itemName`, `itemDesc`, `itemDesc2`, `itemDesc3`, `weight`, `height`, `length`, `width`, `combined_postage`, `item_postage`, `item_postage_amt`, `aust_post_estimate`, `tabs_needed`, `tabhead1`, `tabhead2`, `tabhead3`, `itemDescb`, `itemPrice`, `retPrice`, `specialPrice`, `specs1`, `spechead1`, `specs2`, `spechead2`, `add_comments`, `more_details`, `image1`, `image2`, `image3`, `image4`, `image5`, `cookie`) VALUES
(782, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'IAMS Smart Puppy Large Breed', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: Arial, Helvetica-Normal, serif; font-size: 14px; font-weight: bold;">IAMS Smart Puppy Large Breed</span><br />\r\n	<br />\r\n	<strong><span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Weight:3.6KG<br />\r\n	9KG +$32<br />\r\n	18KG +$74</span></strong><br />\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">&nbsp;<br />\r\n	This Iams ProActive Health formula has PreBiotics that work inside the digestive tract to promote healthy digestion and strong defenses. Healthy inside. Healthy outside.</span></p>\r\n<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Designed for dogs ages 1-24 months,Iams concentrated nutrition proactively nourishes your large-breed puppy to help keep him at his best.</span></p>\r\n<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Natural fish oils with DHA (Docosahexaenoic Acid), a nutrient vital for optimal brain development, promote smarter, more trainable puppies. Protein sourced from chicken and egg helps build strong, firm muscles. Seven essential nutrients nourish the heart while essential minerals promote strong teeth and bones, and antioxidants help maintain a strong immune system.</span></p>\r\n<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">A high-quality protein with no fillers or artificial preservatives, Iams is gentle on the digestive system. Fuel your puppy’s healthy development with 100% complete and balanced nutrition that’s vet recommended and 100% Satisfaction Guaranteed.</span></p>\r\n', NULL, NULL, 4.00, 15, 83, 41, 1, 'flat_rate', 20.00, ' Regular Parcel - $23.30    Express Post - $70.10', 1, 'Description', NULL, NULL, NULL, 25.95, NULL, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item782_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', 'uploads/nopic.jpg', NULL),
(762, NULL, NULL, NULL, '48,24,22,8,12,9', '48,24,22,8,12,9', '0', '29/12/2012 04:25 ', 'TO', 'Font Line Plus for Cats', '<p>\r\n	<span style="line-height: 20px; font-family: Arial, Helvetica-Normal, serif; color: rgb(51,51,51); font-size: 14px; font-weight: bold"><span style="margin-top: 55px">Font Line Plus for Cats</span></span></p>\r\n', NULL, NULL, 16.00, 21, 47, 19, 3, 'aust_post', 0.00, '&nbsp;Regular Parcel - $26.15&nbsp;&nbsp;&nbsp;&nbsp;Express Post - $83.30', 1, 'Description', NULL, NULL, NULL, 44.00, NULL, 33.00, '5kg,6kg,8kg', 'Weight', 'red,blue,green', 'Colour', 'N', NULL, '/uploads/item762_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', 'uploads/nopic.jpg', NULL),
(768, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'Advance Adult Dog Small Breed', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: Arial, Helvetica-Normal, serif; font-size: 14px; font-weight: bold;">Advance Adult Dog Small Breed</span></p>\r\n<p>\r\n	<strong><span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Weight: 1.5KG<br />\r\n	2.5KG +$8.85<br />\r\n	7KG +$41.15<br />\r\n	13KG +$77.80</span></strong><br />\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">&nbsp;<br />\r\n	Adult maintenance food ideal for dogs of normal activity level<br />\r\n	Turkey and Rice as main source of high quality protein<br />\r\n	Beneficial in managing dietary sensitivity<br />\r\n	Formulated to help maintain urinary tract health<br />\r\n	Smaller kibble size ideal for toy to medium sized dogs<br />\r\n	High palatability to tempt fussier eaters </span></p>\r\n', NULL, NULL, 1.50, 5, 16, 16, 1, 'aust_post', 34.55, '&nbsp;Regular Parcel - $12.85&nbsp;&nbsp;&nbsp;&nbsp;Express Post - $21.70', 1, 'Description', NULL, NULL, NULL, 16.40, NULL, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item768_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', 'uploads/nopic.jpg', NULL),
(772, NULL, NULL, NULL, '0', '0', '0', '30/06/2012 00:00 ', 'TO', 'Advance Dog Dental Large and Giant Breeds', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: Arial, Helvetica-Normal, serif; font-size: 14px; font-weight: bold;">Advance Dog Dental Large and Giant Breeds</span><br />\r\n	<br />\r\n	<strong><span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Weight: 3KG<br />\r\n	8KG +$39.20<br />\r\n	15KG +$84.20</span></strong><br />\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">&nbsp;<br />\r\n	For Large and Giant sized Breeds, has specifically designed larger kibble and active ingredients which help to promote and maintain dental health. </span></p>\r\n', NULL, NULL, 0.50, 5, 3, 5, 1, 'free_postage', 0.00, 'Regular Parcel - $6.60    Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 35.05, NULL, 24.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item772_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', 'uploads/nopic.jpg', NULL),
(786, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'Science Diet® - Puppy Small Bites', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: Arial, Helvetica-Normal, serif; font-size: 14px; font-weight: bold;">Science Diet® - Puppy Small Bites</span><br />\r\n	<br />\r\n	<strong><span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Rich in fish oil and nourishing fatty acids.</span></strong></p>\r\n<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: Arial, Helvetica-Normal, serif; font-size: 12px;">Hill''s® Science Diet® Puppy Small Bites dog food provides precisely balanced nutrition to build immunity and enhance mobility for puppies who prefer a smaller kibble. It is enriched with DHA from high quality fish oil and made with high quality ingredients that provide an ideal combination of nutrients, clinically proven antioxidants and vital fatty acids to give your puppy the best start in life.</span></p>\r\n<p>\r\n	<br />\r\n	&nbsp;</p>\r\n', NULL, NULL, 5.00, 17, 12, 17, 3, 'aust_post', 0.00, '&nbsp;Regular Parcel - $15.70&nbsp;&nbsp;&nbsp;&nbsp;Express Post - $34.90', 1, 'Description', NULL, NULL, NULL, 25.00, NULL, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item786_1.jpg', '/uploads/item786_2.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', 'uploads/nopic.jpg', NULL),
(1019, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'IAMS ', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: verdana,arial,helvetica-normal,serif; font-size: 18px; font-weight: normal;">Cat Food</span></p>\r\n', NULL, NULL, 0.50, 29, 10, 8, 1, 'flat_rate', 66.30, ' Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 56.88, NULL, 46.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item1019_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(936, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item936_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(872, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'Gold Listing', '<p>\r\n	<span style="color: rgb(50, 186, 242); line-height: 20px; font-family: verdana, arial, helvetica-normal, serif; font-size: 18px; font-weight: normal;">12 months Gold Listing</span></p>\r\n', NULL, NULL, 0.50, 5, 3, 5, 1, 'flat_rate', 17.00, 'Regular Parcel - $6.60    Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 299.00, NULL, 39.99, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item872_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(874, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'Silver Membership', '<p>\r\n	<span style="color: rgb(50, 186, 242); line-height: 20px; font-family: verdana, arial, helvetica-normal, serif; font-size: 18px; font-weight: normal;">Silver Membership</span></p>\r\n', NULL, NULL, 0.50, 5, 3, 5, 1, 'aust_post', 0.00, '&nbsp;Regular Parcel - $6.60&nbsp;&nbsp;&nbsp;&nbsp;Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 99.00, NULL, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item874_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(876, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'Free Membership', '<p>\r\n	<span style="line-height: 20px; font-family: verdana, arial, helvetica-normal, serif; color: rgb(51,51,51); font-size: 18px; font-weight: normal">Free Membership - 12 months </span></p>\r\n<p>\r\n	<span style="line-height: 16px; font-family: verdana, arial, helvetica-normal, serif; color: rgb(51,51,51); font-size: 14px; font-weight: normal">Directory Listing - List your business with us for FREE</span></p>\r\n', NULL, NULL, 0.50, 5, 3, 5, 10, 'aust_post', 0.00, ' Regular Parcel - $6.60    Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 0.00, NULL, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item876_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(882, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'Bird Food', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: verdana, arial, helvetica-normal, serif; font-size: 18px; font-weight: normal;">Bird Food</span></p>\r\n', NULL, NULL, 0.50, 5, 3, 5, 1, 'flat_rate', 5.00, 'Regular Parcel - $6.60    Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 55.00, NULL, 45.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item882_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(908, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, 'Koi Balance', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 20px; font-family: verdana, arial, helvetica-normal, serif; font-size: 18px; font-weight: normal;">Koi Balance - fish Food</span></p>\r\n', NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 55.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item908_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(886, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, 'Gallery Image', '<p>\r\n	<span style="line-height: 20px; font-family: verdana, arial, helvetica-normal, serif; color: rgb(51,51,51); font-size: 18px; font-weight: normal">Test Gallery</span></p>\r\n', NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', 1, 'Description', NULL, NULL, NULL, 55.00, 0.00, 23.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item886_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(926, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item926_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(928, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item928_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(930, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, 'Test', NULL, NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item930_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(932, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item932_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(934, 'F', NULL, NULL, '0', '0', '0', NULL, NULL, 'Test', NULL, NULL, NULL, 0.00, 0, 0, 0, 1, NULL, NULL, 'Regular Parcel - $6.60    Express Post - $9.55', NULL, 'Description', NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item934_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(906, NULL, NULL, NULL, '4', '4', '0', '27/02/2013 00:00 ', 'TO', 'Bird Food', '<p>\r\n	<span style="color: rgb(51, 51, 51); line-height: 16px; font-family: verdana, arial, helvetica-normal, serif; font-size: 14px; font-weight: normal;">Bird Food</span></p>\r\n', NULL, NULL, 14.50, 18, 3, 17, 1, 'aust_post', 0.00, ' Regular Parcel - $25.20    Express Post - $78.90', 1, 'Description', NULL, NULL, NULL, 44.00, NULL, 0.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/item906_1.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL),
(1045, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, 'testing', NULL, NULL, NULL, 6.50, 30, 3, 5, 1, 'aust_post', 0.00, '&nbsp;Regular Parcel - $17.60&nbsp;&nbsp;&nbsp;&nbsp;Express Post - $43.70', NULL, 'Description', NULL, NULL, NULL, 44.00, NULL, 32.00, NULL, NULL, NULL, '', 'N', NULL, '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', '/uploads/nopic.jpg', NULL);

-- --------------------------------------------------------

Open in new window

0
Comment
Question by:sabecs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Terry Woods earned 500 total points
ID: 39984873
To do it in a single query, I believe it needs to be done like this:
insert into items ( 
  `item_type`,
  `min_order`,
  `prodcode`,
  `true_stock_count`,
  `display_stock_count`,
  `low_stock_count`,
  `date_time_expires`,
  `limit_availability`,
  `itemName`,
  `itemDesc`,
  `itemDesc2`,
  `itemDesc3`,
  `weight`,
  `height`,
  `length`,
  `width`,
  `combined_postage`,
  `item_postage`,
  `item_postage_amt`,
  `aust_post_estimate`,
  `tabs_needed`,
  `tabhead1`,
  `tabhead2`,
  `tabhead3`,
  `itemDescb`,
  `itemPrice`,
  `retPrice`,
  `specialPrice`,
  `specs1`,
  `spechead1`,
  `specs2`,
  `spechead2`,
  `add_comments`,
  `more_details`,
  `image1`,
  `image2`,
  `image3`,
  `image4`,
  `image5`,
  `cookie`)
select 
  `item_type`,
  `min_order`,
  `prodcode`,
  `true_stock_count`,
  `display_stock_count`,
  `low_stock_count`,
  `date_time_expires`,
  `limit_availability`,
  `itemName`,
  `itemDesc`,
  `itemDesc2`,
  `itemDesc3`,
  `weight`,
  `height`,
  `length`,
  `width`,
  `combined_postage`,
  `item_postage`,
  `item_postage_amt`,
  `aust_post_estimate`,
  `tabs_needed`,
  `tabhead1`,
  `tabhead2`,
  `tabhead3`,
  `itemDescb`,
  `itemPrice`,
  `retPrice`,
  `specialPrice`,
  `specs1`,
  `spechead1`,
  `specs2`,
  `spechead2`,
  `add_comments`,
  `more_details`,
"/uploads/item1063_1_copy.jpg",
  `image2`,
  `image3`,
  `image4`,
  `image5`,
  `cookie`
from items
where id = 782

Open in new window


I've left out the id column since it auto-increments, and hard-coded the value to go into the image1 column to the given value.

An alternative method would be to not hardcode the image1 value, but do a separate update query which instead updates the newly inserted row.
0
 

Author Closing Comment

by:sabecs
ID: 39987598
Thanks for your help Terry .
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question