i am having problems with the following update query,
"update info set info.name = temp.temp_name, info.age = temp.temp_age where temp.temp_id = 1 and info.id = temp.info_id;"
what i am trying to do is get the values of 2 fields from table temp into a record from table info. the ID for the record in the info table is stored in the field info_id on table temp.
is this clear what i am trying to do ??
the error i am getting is "unknown table test in where clause".
I am new to mysql so please be gentle
cheers
Jamie
"update info set info.name = temp.temp_name, info.age = temp.temp_age where temp.temp_id = 1 and info.id = temp.info_id;"
what i am trying to do is get the values of 2 fields from table temp into a record from table info. the ID for the record in the info table is stored in the field info_id on table temp.
is this clear what i am trying to do ??
the error i am getting is "unknown table test in where clause".
I am new to mysql so please be gentle
cheers
Jamie