Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Normally used to MySQL so need help on syntax check.

with SELECT * FROM Bit WHERE CustomerID='3512242' I have a field called Filer. I want to change it from a P to a D. Do I use UPDATE to change the value?

share|improve this question

closed as off topic by Paul White, Jon Seigel, Mark Storey-Smith, Marian, RolandoMySQLDBA Dec 3 '12 at 17:04

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 3 down vote accepted
UPDATE dbo.Bit
  SET Filer = 'D'
  WHERE CustomerID = '3512242'
  AND Filer = 'P';

Documentation for UPDATE with many examples.

share|improve this answer
oops i didn't see that when i read the mysql ,thought she looking for mysql syntax – Biju jose Nov 28 '12 at 5:21
@Bijujose The syntax for updating one table is pretty much the same in MySQL, too. – ypercubeᵀᴹ Nov 28 '12 at 20:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.