Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    9

    Unanswered: Inserting identical data in multiple rows under one column SQL.

    Hi there,

    Example:

    I have a table named "inventory". I have one field which is called "itemID". There are 250 items in the database. I then add a new field which is called "itemDate". I now need to insert 10/12/2005 for each row in the datebase under the "itemDate" column. Doing this 250 times would obviously be a little time consuming.

    How would one write this SQL to populate a column with the same data?

    Thanks very much.

  2. #2
    Join Date
    Jun 2005
    Posts
    23
    Code:
    UPDATE inventory
     SET itemDate='2005-10-12'
    I assume you have declared the itemDate column as date

Posting Permissions

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