Re: sql command - copy of one row

2001-03-19 Thread - = k o l i s k o = -
gt; Cc: <[EMAIL PROTECTED]> Sent: Monday, March 19, 2001 12:56 PM Subject: Re: sql command - copy of one row > On Mon, Mar 19, 2001 at 12:51:27PM +0100, - = k o l i s k o = - wrote: > > Hi! > > > > i try one little question. > > > > when the table2

Re: sql command - copy of one row

2001-03-19 Thread Peter Pentchev
On Mon, Mar 19, 2001 at 12:51:27PM +0100, - = k o l i s k o = - wrote: > Hi! > > i try one little question. > > when the table2 have one more row then table1.. is possible try something > like this: > > insert into table2 ($date, select * from table1 where username = '$uname') One more 'column

Re: sql command - copy of one row

2001-03-19 Thread - = k o l i s k o = -
Hi! i try one little question. when the table2 have one more row then table1.. is possible try something like this: insert into table2 ($date, select * from table1 where username = '$uname') where $date -> system time and date generated from php. If you understand.. table2 is backup of table1

Re: sql command - copy of one row

2001-03-19 Thread - = k o l i s k o = -
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 =

Re: sql command - copy of one row

2001-03-19 Thread Peter Pentchev
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

sql command - copy of one row

2001-03-19 Thread - = k o l i s k o = -
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 g