is there a way that i can copy an info from, for example, i have 3 date fields namely:
date previousdate postupdate
----- -------------- *******
is there a way that i can update the field previousdate and copy the content of the postupdate, in this case, i want to copy the asterisks to previousdate then update new postupdate?
copy info from one field to another
Moderator: General Moderators
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
Code: Select all
UPDATE tablename SET postupdate=previousdate WHERE condition;