Hi ----- Original Message ----- From: "W. Enserink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 4:34 PM Subject: copying a row
> Hi all, > > > Im in need of some tps. > > I want to copy a row in a table to a new row in the same table except for > the unique ID. Is there some mysql statement for this? It should work something like : set @a:=''; set @b:='' .... set @n:=''; set a variable for each item which you need to insert in to table. select @a:=ITEM1,@b:=ITEM2...@n:ITEMn from your_table where..... insert into your_table values(@a,@b....@n) Regards, Gelu > > regards Wilbert > > > > ------------------------- > Pas de Deux > Van Mierisstraat 25 > 2526 NM Den Haag > tel 070 4450855 > fax 070 4450852 > http://www.pdd.nl > [EMAIL PROTECTED] > ------------------------- > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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