Need to move column vals to another table

[ppowell]

I tried this:

UPDATE interns i, intern_complete_application ica SET i.is_complete = ica.is_complete WHERE i.id = ica.intern_id

However, I get a SQL Syntax error upon doing so:

Error 1064: You have an error in your SQL syntax near i, intern_complete_application ica SET i.is_complete = ica.is_complete WHERE i.i' at line 1

This is a time-sensitive issue that needs resolving immediately. I am using MySQL 3.23.41

Please help!
Phil

[nemonoman]

There is no support for the very creative sql statement that you have constructed.

There may be other ways, but for expediency, best is to use a loop:

UPDATE interns i, intern_complete_application ica SET i.is_complete = ica.is_complete WHERE i.id = ica.intern_id

$result=mysql_query("SELECT intern_id FROM intern_complete_application WHERE is_complete = 1");

//NOTE: I don't know what you're using for 'is_complete'

while($row=mysql_fetch_array($result)){
mysql_query("UPDATE interns SET is_complete =1 WHERE id=$row[0]");
}