hello, i am not sure if this is the right group to ask this question but here goes.. i have a HUGE database (30+megs) which has just been converted from microsoft access to mysql (yay!) .. the original designer had five separate fields for keywords
ie keyword1, keyword2, keyword3,keyword4,keyword5 I would like to create a new field called 'keywords' (very original i know) which has the value from each of these fields separated by a comma. ie. keywords=' keyword1, keyword2, keyword3,keyword4,keyword5'; i need to loop through the entire database and do this for every row.. i could write a php script to do this butit would probably cause a cgi timeout .. so i would rather do it from the mysql command line.. (i am on win2k) could someone help? much appreciated brendan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
