[RESOLVED] Populating Multiple Rows With Same Data

[Tim_Silva]

Hi,

This is a very beginner's question. I have a mySQL database with 100 rows. I just created a new field (subjectID). All the rows in this new field will have the same data, the number "3". Would somebody please inform me on the command to insert this data in all the rows at the same time.

Thanks in advance,

Tim

[Piranha]

UPDATE table SET subjectId = 3

[Tim_Silva]

Thanks Piranha

Tim