Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

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.

1 Answer

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
add comment

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