Professional Web Applications Themes

copying a row from one table to another? - MySQL

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

Sponsored Links
  1. #1

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


    Sponsored Links
    Jim Michaels Guest

  2. #2

    Default Re: copying a row from one table to another?

    [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
    Geoff Muldoon Guest

  3. #3

    Default Re: copying a row from one table to another?

    "Geoff Muldoon" <geoff.muldoontrap.> wrote in message
    news:MPG.1e78ae4ea903918098977dnews.readfreenews. net...
    > [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?


    Jim Michaels Guest

  4. #4

    Default Re: copying a row from one table to another?

    [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
    Geoff Muldoon Guest

  5. #5

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



    Jim Michaels Guest

  6. #6

    Default Re: copying a row from one table to another?

    "Jim Michaels" <NOSPAMFORjmichae3> wrote in message
    news:L_WdndyUQMv_i5PZRVn-vQcomcast.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.


    Bill Karwin Guest

Similar Threads

  1. Copying complete table from one MSSQL database toanother
    By lther in forum Coldfusion Database Access
    Replies: 6
    Last Post: August 16th, 05:34 AM
  2. Trouble copying data from old table to new table
    By RelentlessMike in forum Coldfusion Database Access
    Replies: 3
    Last Post: May 19th, 05:01 PM
  3. Forms...Copying data from one table to another
    By Paul G. in forum Microsoft Access
    Replies: 2
    Last Post: July 16th, 05:21 PM
  4. Copying entire table
    By Sudaraka Wijesinghe in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 3rd, 04:50 PM
  5. Beginner - copying data from one table to another
    By Mark Muller in forum Oracle Server
    Replies: 2
    Last Post: December 6th, 09:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139