Closed rob625 closed 4 years ago
Created rtx.txt manually from orariodef1.pdf Loaded to ricevimento:
LOAD DATA INFILE 'C:/xfer/test/rxt.txt' INTO TABLE ricevimento FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
(should probably have been '\r\n')
added column pr
UPDATE ricevimento R join prof P on substr (R.n, 1, -1+length(R.n) = concat(P.cognome, " ", P.nome) SET R.pr=P.id WHERE R.pr IS NULL
Created rtx.txt manually from orariodef1.pdf Loaded to ricevimento:
LOAD DATA INFILE 'C:/xfer/test/rxt.txt' INTO TABLE ricevimento FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
(should probably have been '\r\n')
added column pr
UPDATE ricevimento R join prof P on substr (R.n, 1, -1+length(R.n) = concat(P.cognome, " ", P.nome) SET R.pr=P.id WHERE R.pr IS NULL