1 -- import students enrolled for this year
3 drop table fer_upisani_2011 ;
5 create table fer_upisani_2011 (
6 jmbag varchar(10) primary key,
13 LOAD DATA INFILE '/srv/ferlib2koha/report_62836_1026_Aktivni_studenti.unl' INTO TABLE fer_upisani_2011
14 FIELDS TERMINATED BY '#'
15 LINES TERMINATED BY '\r\n'
18 select count(*) from fer_upisani_2011
24 select borrowernumber,userid,email,dateexpiry
26 where categorycode='S' and length(userid) > 0 and dateexpiry > '2011-09-30'
30 select borrowernumber,userid,dateexpiry,jmbag,nick
32 full join fer_upisani_2011 on nick = userid
33 where categorycode='S' and length(userid) > 0 and dateexpiry > '2011-09-30' ;
38 set dateexpiry='2011-09-30'
39 where categorycode='S' and length(userid) > 0 and dateexpiry > '2011-09-30'
42 update borrowers,fer_upisani_2011
43 set dateexpiry='2012-10-31'
44 where categorycode='S' and length(userid) > 0 and nick = userid