Inserting identical data in multiple rows under one column SQL.

ricoche · #1 (**permalink**) 10-14-05, 06:16

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.

tombell · #2 (**permalink**) 10-14-05, 07:35

Code:

UPDATE inventory
 SET itemDate='2005-10-12'

I assume you have declared the itemDate column as date

Internet Services

Web Development

Digital Marketing

Consumer Tech