[email]NOSPAMFORjmichae3[/email] says...Close but no cigar. Try INSERT INTO .. SELECT ..> 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.
GM
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....
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.
Re: copying a row from one table to another? [email]NOSPAMFORjmichae3[/email] says...Close but no cigar. Try INSERT INTO .. SELECT ..> 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.
GM
Re: copying a row from one table to another? "Geoff Muldoon" <geoff.muldoontrap.> wrote in message
news:MPG.1e78ae4ea903918098977dnews.readfreenews. net...will this feature work on 4.x databases?> [email]NOSPAMFORjmichae3[/email] 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
Re: copying a row from one table to another? [email]NOSPAMFORjmichae3[/email] says...IIRC since at least 3.something. See:> "Geoff Muldoon" <geoff.muldoontrap.> wrote in message>> > [email]NOSPAMFORjmichae3[/email] 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?
[url]http://dev.mysql.com/doc/refman/4.1/en/insert-select.html[/url]
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
Re: copying a row from one table to another?
"Geoff Muldoon" <geoff.muldoontrap.> wrote in message
news:MPG.1e78b96b58a9caf998977enews.readfreenews. net...> [email]NOSPAMFORjmichae3[/email] says...>>> "Geoff Muldoon" <geoff.muldoontrap.> wrote in message>>>> > [email]NOSPAMFORjmichae3[/email] 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:
> [url]http://dev.mysql.com/doc/refman/4.1/en/insert-select.html[/url]
>
> 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...
Re: copying a row from one table to another? "Jim Michaels" <NOSPAMFORjmichae3> wrote in message
news:L_WdndyUQMv_i5PZRVn-vQcomcast.com...Yes, it is standard SQL syntax.> I am a little curious if it's not standard SQL syntax (can I use this on
> other databases?),
Virtually all RDBMS brands today should support it. Don't know which one
you have in mind.
Regards,
Bill K.
Posting Permissions
Bookmarks