Hi!
> On Mon, Mar 19, 2001 at 12:22:09PM +0100, - = k o l i s k o = - wrote:
> > Hi!
> >
> > I have a problem. I would like copy one row from table1 to
> > another table2. How could I do?
> >
> > I tried something like this:
> >
> > insert into table2 values (select * from table1 where username =
'$uname')
> >
> > both (table1 and table2) have the same structure.
> > Every time when I try do this sql command i get syntax error in sql
command.
>
> Is there really an SQL server that would accept this query? Try just:
>
> insert into table2 select * from table1 where username = '$uname';
Yes!
It is working fine!
Thank You very much.
>
> G'luck,
> Peter
>
> --
> because I didn't think of a good beginning of it.
>
> ---------------------------------------------------------------------
> 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
