Forum

Após entrar com putty ou ferramenta de gerencia mysql so usar esse script sql

UPDATE sis_adicional SET mac = (SELECT radacct.callingstationid FROM radacct WHERE sis_adicional.username = radacct.username AND radacct.radacctid = (SELECT MAX(r.`radacctid`) FROM radacct r WHERE r.username = radacct.username)) WHERE 1