atualizar valores num campo de uma tablela com dados do campo de outra tabela cujos registos tenham em comum um campo

eduardo
28 Sep 2016

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;

moodle e módulos através do git

eduardo
26 Sep 2016

moodle
$ cd /path/to/your/webroot
$ git clone git://git.moodle.org/moodle.git moodle - clonar moodle para a pasta moodle
$ cd moodle
$ git branch -a - mostra os ramos
$ git branch --track MOODLE_29_STABLE origin/MOODLE_29_STABLE - cria um ramo local e prepara-o para fazer o track desse ramo com o remoto da versão MOODLE_29_STABLE
$ git checkout MOODLE_29_STABLE - muda para o novo ramo local

Bring back deleted files with lsof

eduardo
24 Sep 2016

Author: Michael Stutz
There you are, happily playing around with an audio file you've spent all afternoon tweaking, and you're thinking, "Wow, doesn't it sound great? Lemme just move it over here." At that point your subconscious chimes in, "Um, you meant mv, not rm, right?" Oops. I feel your pain -- this happens to everyone. But there's a straightforward method to recover your lost file, and since it works on every standard Linux system, everyone ought to know how to do it.

Subscrever