[RESOLVED] MySQL update statement

[spiritssight]

Hello,

I am wondering how can I do a update statement that update the whole record?

I have to tables they both have the same information in them same setup and so on,

ok table 1 (irs_rawdata) gets data added from file
table 2 has some of the same record based on the FIN no other information matters

I want the information in table 1 to be updated in table 2 even if its the same information, the code I have is:

			$query_u = "UPDATE irs_query SET * FROM irs_rawdata WHERE fin='$fin'"
			$result_u = mysql_query($query_u) OR die("Sorry was unable to insert and select the records from the db table irs_rawdata! <br />" . mysql_error());
			$query_d = "DELETE FROM irs_rawdata WHERE EIN='$fin'";
			$result_d = mysql_query($query_d) OR die("Was unable delete ".$fin." from the db table irs_rawdata! <br />" . mysql_error());

Thanks for your help!

Sincerely,
Christopher