SQL Query/Update

[badkarma1399]

Hi, I'm currently trying to learn a bit of SQL, but I need some help forming a query...well an update to be exact. I have a table (called snails) that contains several characteristics for each record (their height, length, etc). Lets say I wanted multiply two of these characteristics together, and update that product to a third column? (Let say named height*length) Further, I'd like to do this for each record. Anyone know how to do this? Thanks for reading and any help.

 

[KLin]

UPDATE snails set column3 = height*length

This better not be a homework question.

 

[BoberFett]

This really should be covered by any SQL for Dummies book. Updates don't get simpler than this.