Need to insert a static value into a field in all records of my DB

I have a database with thousands of records. I need to change one field to a value of 1 for each record in the database.

Something like...
INSERT INTO mydataset (myfield) VALUES (1)

but I don't think that is looping through the DB. I want to do this with an SQL query directly, no PHP.

thanks.
brian
LVL 1
befidledAsked:
Who is Participating?
 
Rikin ShahConnect With a Mentor Microsoft Dynamics CRM ConsultantCommented:
UPDATE mydataset
SET  myfield = '1'
--put a Where conditions if any
0
 
befidledAuthor Commented:
Perfect, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.