use novomoodle;
update mdl_user, users set mdl_user.username=users.uid where mdl_user.email=users.mail and mdl_user.auth='oidc';
UPDATE
Sales_Import SI,
RetrieveAccountNumber RAN
SET
SI.AccountNumber = RAN.AccountNumber
WHERE
SI.LeadID = RAN.LeadID;
#mysql -u root -p
create database novomoodle default character set utf8;
grant all privileges on novomoodle.* to 'spider'@'localhost' identified by 'spider';
#mysql -u root -p novomoodle < ../novomoodle_bak/novomoodle_30.sql
#git checkout MOODLE_30_STABLE
atualizar
#rm -r mod/lti
#git checkout MOODLE_30_STABLE
#rm -r mod/lti
atualizar
desinstalar:
auth/lti e enroll/lti e mod/lti
#mysql -u root -p
update mdl_user set auth='oidc' where auth='openid';
update mdl_user set password='not cached' where auth='oidc' and password!='not cached';
delete from mdl_user where email=''; - 52 registos
select count(distinct username) from mdl_user; - contar o número de registos da tabela mdl_user cujo campo username é único
select *, count(email) from mdl_user group by email having count(email)>1;
delete from mdl_user where email='hugo-monteiro29@hotmail.com' and auth='manual';
update mdl_user, users set mdl_user.username=users.uid where mdl_user.email=users.mail and mdl_user.auth='oidc'; - 1312 registos
http://stackoverflow.com/questions/224732/sql-update-from-one-table-to-…