Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
01-05-2012, 04:26 PM #1
- Join Date
- Oct 2009
- Thanked 3 Times in 3 Posts
copy field content to another field in same table
How do I copy content from one field to another when both field are in the same table?
01-05-2012, 09:17 PM #2
If you only want that to happen for *some* values, then just add a WHERE clause:Code:UPDATE tablename SET tofield = fromfield
Code:UPDATE tablename SET tofield = fromfield WHERE somecondition
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.