"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...