Never mind, I just figured it out: First, I copied the whole 'hits' table to 'hits_bak', then ran this:
INSERT INTO `csrtech_dirserv`.`hits` SELECT `SID` , 2 AS `AID` , `Phrase` , `IP` , `Link` , `Time` , `Amt` , `F` FROM `csrtech_dirserv`.`hits_bak` WHERE `SID` =5 So that coppied all fields except AID, which it set to 2. Hope this helps someone else! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
