Professional Web Applications Themes

insert question - MySQL

I'm a bit new to all types of sql and can't seem to find the answer to this question. I want to insert a row where several columns have the same initial value. Is there a way to do this without repeating the value multiple times on the insert command? E.g., instead of INSERT INTO Table1 (Column1, Column2, Column3.) VALUES (Value, Value, Value .) something like this: insert into table1 (column1, column2, column3...) values (3xValue...) Thanks Jeff -- Posted via a free Usenet account from http://www.teranews.com...

  1. #1

    Default insert question

    I'm a bit new to all types of sql and can't seem to find the answer to this
    question.

    I want to insert a row where several columns have the same initial value. Is
    there a way to do this without repeating the value multiple times on the
    insert command? E.g., instead of

    INSERT INTO Table1 (Column1, Column2, Column3.)
    VALUES (Value, Value, Value .)

    something like this:
    insert into table1 (column1, column2, column3...)
    values (3xValue...)

    Thanks

    Jeff


    --
    Posted via a free Usenet account from http://www.teranews.com

    Jeff Guest

  2. #2

    Default Re: insert question

    Jeff wrote: 

    No, there is no syntax in SQL for what you describe.

    The only other solution I can think of right now is to declare that
    value as the DEFAULT for the columns in question, and then do not give a
    value for them in the insert statement.

    Regards,
    Bill K.
    Bill Guest

  3. #3

    Default Re: insert question

    Bill Karwin wrote: 
    >
    > No, there is no syntax in SQL for what you describe.
    >
    > The only other solution I can think of right now is to declare that
    > value as the DEFAULT for the columns in question, and then do not give a
    > value for them in the insert statement.
    >
    > Regards,
    > Bill K.[/ref]

    Defaults get my vote. Anything else would make me wonder about the
    design of the database.
    Jonathan Guest

Similar Threads

  1. 'insert into' question
    By Claude in forum MySQL
    Replies: 3
    Last Post: November 19th, 08:57 AM
  2. [MX Kollection] Insert record question
    By G.B. in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 0
    Last Post: July 13th, 08:40 AM
  3. Insert Question
    By LukeDD in forum Coldfusion - Getting Started
    Replies: 6
    Last Post: June 27th, 10:32 PM
  4. MySql insert question.
    By phatnugs420@comcast.net in forum PHP Development
    Replies: 0
    Last Post: October 12th, 08:48 PM
  5. Insert Behavior Question??
    By Kory in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 10th, 03:24 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