copying a row from one table to another?
This is a discussion on copying a row from one table to another? within the MySQL Database forums, part of the Database Forums category; how do I copy a row from one table to another? I thought it might be something like SELECT...INTO, ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-07-2006
|
|||
|
|||
Re: copying a row from one table to another?
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 
|
|
03-07-2006
|
|||
|
|||
|
Re: copying a row from one table to another?
"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?
|
|
03-07-2006
|
|||
|
|||
|
Re: copying a row from one table to another?
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
|
|
03-07-2006
|
|||
|
|||
|
Re: copying a row from one table to another?
"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...
|
|
03-08-2006
|
|||
|
|||
|
Re: copying a row from one table to another?
"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.
|
Linear Mode
