Re: How can I update or replace columns in one table with columns from another table?

[Pedro Ribeiro]

Example code i'm using for something similar ...

INSERT radtemp (UserName,VLAN)
SELECT DISTINCT ui.UserName,rp.VLAN
FROM userinfo AS ui,alunos.RadiusProfiles AS rp,alunos.Bindings AS bi
WHERE rp.VLAN != 0
AND ui.UserName LIKE '%@%'
AND SUBSTRING_INDEX(ui.UserName,'@',-1) = rp.Dominio
AND ui.UserName = CONCAT(bi.User,'@',bi.Domain)
AND (bi.CodigoCurso = rp.CodigoCurso OR rp.CodigoCurso = 0);

Bad example ?? see INSERT ... SELECT
http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html