mysql -u root -p -D ovckb --default-character-set=utf8
awk -F , -v s="'"  '{ print "INSERT INTO
 awk -F , -v s="'"  '{ print "INSERT INTO ppl ( login, naam0, naam2, naam1, type ) VALUES ( " s $1 s ", " s $2 s ", " s $3 s ", " s $4 s ", " s "leerling" s " ) ON DUPLICATE KEY UPDATE naam0 = " s $2 s ", naam2 = " s $3 s ", naam1 = " s $4 s ";" }' > namen