this is probably a very easy one bu

[CompGirl]

this is probably a very easy one but i just started today with sql programming.. the thing i wanted to ask is how to set the same values in a column with one simple command...

for example

name grade
anna 5
donna 5
albert 5

in this example... if i know that they all have five and they are the only ones in my db... can i just use one sql command do write 5 to all of them??

 

[collierd]

Use the set command

i.e. update <table>
set grade = 5


Damian.

 

[CompGirl]

thx alot

 

[SQLBill]

You can also add the WHERE command if you only need to update some.

Let's say you have 5 people and you only need to update those 3.

update <table>
set grade = 5
where [name] in ('anna', 'donna', 'albert')

BTW-you should NOT used reserved words for table or column names. If you do, you need to enclose them in square brackets [] or single quotes ' '.

-SQLBill

 

[CompGirl]

that was my next issue... thx for the tip