copying a row from one table to another?

how do I copy a row from one table to another?
I thought it might be something like SELECT...INTO, but I could be wrong.

NOSPAMFORjmichae3@yahoo.com says...
> how do I copy a row from one table to another?
> I thought it might be something like SELECT...INTO, but I could be wrong.

Close but no cigar. Try INSERT INTO .. SELECT ..

GM

"Geoff Muldoon" <geoff.muldoon@trap.gmail.com> wrote in message
news:MPG.1e78ae4ea903918098977d@news.readfreenews. net...
> NOSPAMFORjmichae3@yahoo.com says...
>> how do I copy a row from one table to another?
>> I thought it might be something like SELECT...INTO, but I could be wrong.
>
> Close but no cigar. Try INSERT INTO .. SELECT ..
>
> GM

will this feature work on 4.x databases?

NOSPAMFORjmichae3@yahoo.com says...
> "Geoff Muldoon" <geoff.muldoon@trap.gmail.com> wrote in message
> > NOSPAMFORjmichae3@yahoo.com says...
> >> how do I copy a row from one table to another?
> >> I thought it might be something like SELECT...INTO, but I could be wrong.
> >
> > Close but no cigar. Try INSERT INTO .. SELECT ..
> >
> > GM
>
> will this feature work on 4.x databases?

IIRC since at least 3.something. See:
http://dev.mysql.com/doc/refman/4.1/...rt-select.html

Guess that you're a newbie, but next time RTFM, it's all there and is
pretty easy to search for such simple and basic stuff.

GM

"Geoff Muldoon" <geoff.muldoon@trap.gmail.com> wrote in message
news:MPG.1e78b96b58a9caf998977e@news.readfreenews. net...
> NOSPAMFORjmichae3@yahoo.com says...
>> "Geoff Muldoon" <geoff.muldoon@trap.gmail.com> wrote in message
>> > NOSPAMFORjmichae3@yahoo.com says...
>> >> how do I copy a row from one table to another?
>> >> I thought it might be something like SELECT...INTO, but I could be
>> >> wrong.
>> >
>> > Close but no cigar. Try INSERT INTO .. SELECT ..
>> >
>> > GM
>>
>> will this feature work on 4.x databases?
>
> IIRC since at least 3.something. See:
> http://dev.mysql.com/doc/refman/4.1/...rt-select.html
>
> Guess that you're a newbie, but next time RTFM, it's all there and is
> pretty easy to search for such simple and basic stuff.
>
> GM


Don't like to admit it, but I suppose I am compared to some. I knewI was
searching the manual for something I had seen like that, but I was searching
for the wrong thing. I have never had to use this kind of statement before.
I am a little curious if it's not standard SQL syntax (can I use this on
other databases?), but then that would probably show you how much more of a
newbie I am to SQL...

"Jim Michaels" <NOSPAMFORjmichae3@yahoo.com> wrote in message
news:L_WdndyUQMv_i5PZRVn-vQ@comcast.com...
> I am a little curious if it's not standard SQL syntax (can I use this on
> other databases?),

Yes, it is standard SQL syntax.

Virtually all RDBMS brands today should support it. Don't know which one
you have in mind.

Regards,
Bill K.