aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/install/module-naplo/mysql/createAccount.txt
blob: 57b17ac5b9dc5792d424878384cab9273e36e100 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
select
        trim(concat_ws(' ',viseltNevElotag,viseltCsaladiNev,viseltUtonev)) as nev,
	substring_index(substring(dn,5),',',1) as userAccount,
	'1212' as jelszo,
	substring_index(substring_index(dn,',ou=diak',1),'=',-1) as kategoria,
	oId as studyId
    from diak
    where dn like '%ou=7b%'
    into outfile '/tmp/7b.dat';

select trim(concat_ws(' ',viseltNevElotag,viseltCsaladiNev,viseltUtonev)) as nev,
substring_index(substring(dn,5),',',1) as userAccount, '1212' as jelszo,
'diák' as kategoria, oId as studyId
from diak where dn like '%ou=7b%' into outfile '/tmp/7b.dat';