DokuWiki

This is an old revision of the document!

---

Exporter la liste des cours à dupliquer

select id,shortname,fullname,visible from mdl_course where shortname LIKE '%[21-22]%'
INTO OUTFILE '/tmp/export-courses.csv' 
FIELDS ENCLOSED BY '"' 
TERMINATED BY ';' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';