Normally I'd say do a select...into...from, but I don't think MySQL supports that. In lew of that, try this:
(1) Create the new table. CREATE TABLE tbl_table_b ( record SMALLINT NULL, id SMALLINT NULL, color VARCHAR(10) ); (2) Insert the values from the source table to the destination. INSERT INTO tbl_b SELECT record, id, color FROM tbl_a; (3) Update the values you want changed. UPDATE tbl_b SET record = 2 id = 001 WHERE color = 'Pink'; <Continue for each additional row to be updated> Not sure if this is what you were after. Regards, A$ ----- Original Message ----- From: Brent Elison <[EMAIL PROTECTED]> Date: Friday, August 1, 2003 11:19 am Subject: Newbie question...memo field > Hi all, > > I'm fairly new to MySQL and have the following scenario: > > The Table-A below was converted from a Filemaker Pro database. > The color > field was a value list in the FMP database that converted over as > a text > field. The color field contains all the selected values in the > value list > (from the FMP database) and looks like the data below (Table-A) > when viewed > in the BLOB-editor (MySQL-Front). So, how do I extract the color > valuesfrom the color field in Table-A and put them into a separate > table looking > like Table-B? > > Sorry for the totally newbie question. Thanks for any suggestion. > > Brent > > > Table-A > Record ID Color > ------------------------ > 1 001 Black > Pink > White > 2 002 Black > 3 003 Green > 4 AAA Black > White > ------------------------ > > > Table-B > Record ID Color > ------------------------ > 1 001 Black > 2 001 Pink > 3 001 White > 4 002 Black > 5 003 Green > 6 AAA Black > 7 AAA White > ----------------------------- > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
