Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving data in same table

Status
Not open for further replies.
kupe

kupe

Technical User
Sep 23, 2002
376
In the same table, TableOne, I'd like to move information from FieldOne to FieldFour where DoA is null. How is it done, please, Experts?
 
Sort by date Sort by votes
How about:
[tt]
UPDATE tableone
SET fieldfour=fieldone
WHERE doa IS NULL
[/tt]
 
Upvote 0 Downvote
You make it look so simple, Tony! Thanks very much.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
492
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
479
lupidol
lupidol
waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
375
SkipVought
S
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
549
EdLentz
EdLentz
bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
393
bharons
bharons

Part and Inventory Search

Sponsor

Back
Top