Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

Move field value to another via SQL

May 30, 2000, 5:33 AM
Robert
Enthusiast (901 posts)
Robert's avatar
May 30, 2000, 5:33 AM
Post #1 of 2
Views: 1686
Shortcut
Quote Reply
Move field value to another via SQL
I have just another field named Hits2; as the first function in builld.cgi, i want to move all values in Hits to Hits2. May you tell me if there is an SQL-Statement for that?
Robert

May 31, 2000, 2:10 AM
pugdog
Veteran / Moderator (6956 posts)
May 31, 2000, 2:10 AM
Post #2 of 2
Views: 1627
Shortcut
Quote Reply
Re: Move field value to another via SQL In reply to
In the SQL Monitor:

UPDATE Links Set Hits2=Hits

Should do it.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/