User Tools

Site Tools


moodle-requete-doublons

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
moodle-requete-doublons [2022/03/16 10:40] – created 172.16.7.218moodle-requete-doublons [2023/09/28 12:26] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ======Doublons====== ======Doublons======
 <code> <code>
-select count(*), username from mdl_user goup by trim(username) HAVING   COUNT(*) > 1+SELECT   id,COUNT(*) AS nbr_doublon,FROM_UNIXTIME(timecreated), username,lastname,firstname,auth FROM     mdl_user GROUP BY trim(username) HAVING   COUNT(*) > 1;
 </code> </code>
moodle-requete-doublons.1647427242.txt.gz · Last modified: 2023/09/28 12:26 (external edit) · Currently locked by: 216.73.217.114