Professional Web Applications Themes

insert into...select using the same table - MySQL

How can I do the following in MySQL. insert into table1 (col1, col2, col3) select col1, col2, somevalue as col3 from table1 MySQL doesn't allow you to select from the same table you are inserting into. Thank You...

  1. #1

    Default insert into...select using the same table

    How can I do the following in MySQL.

    insert into table1 (col1, col2, col3)
    select col1, col2, somevalue as col3
    from table1

    MySQL doesn't allow you to select from the same table you are inserting
    into.

    Thank You
    Don Vaillancourt Guest

  2. #2

    Default Re: insert into...select using the same table

    "Don Vaillancourt" <donvwebimpact.com> wrote in message
    news:VBjUf.15449$43.2817nnrp.ca.mci.com!nnrp1.uun et.ca...
    > How can I do the following in MySQL.
    >
    > insert into table1 (col1, col2, col3)
    > select col1, col2, somevalue as col3
    > from table1
    One way would be to store the result of the select in a temporary table, and
    then copy that back to table1.

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default Re: insert into...select using the same table

    Ok, did some research and got the answer.

    It does work on 4.0.14 and higher.



    Don Vaillancourt wrote:
    > How can I do the following in MySQL.
    >
    > insert into table1 (col1, col2, col3)
    > select col1, col2, somevalue as col3
    > from table1
    >
    > MySQL doesn't allow you to select from the same table you are inserting
    > into.
    >
    > Thank You
    Don Vaillancourt Guest

Similar Threads

  1. What's faster - loop for insert or insert...select.
    By mr. modus in forum Coldfusion Database Access
    Replies: 2
    Last Post: December 10th, 01:57 AM
  2. How Do you insert a table in Previous Table
    By jaze18 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 3rd, 07:46 PM
  3. Replies: 0
    Last Post: July 23rd, 11:30 PM
  4. Insert from Select
    By RPhillips@ce-a.com in forum Informix
    Replies: 6
    Last Post: July 30th, 10:16 PM
  5. Insert into <table w/ text column> select distinct ...
    By Adam Nester in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 30th, 04:38 PM

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