当日期报错，设置日期格式
set datestyle ='iso,mdy'; copy lab4.chirpusers from stdin using delimiters '|'; 101|jsorp2c7|sirius|11/1/15|12 grimauld pl. london|h|4343.45|\n|0 102|8rhg2ive|lavender|08/14/2015|121 west lane, london|h|76543.5|\n|1 103|aijad9fs|padma|3/4/15|tottenham court road, london|h|45500|\n|1 104|zv67luib|lee|11/16/15|124, 41st ave west, new york|h|190000|\n|1 105|qpvlxgbq|roweena|12/28/15|112, abbey road, london|\n|300000|\n|0 106|npaelkwz|lily|12/26/15|west country, england|u|180870.56|107|\n 107|fosxeu92|james|12/26/15|\n|g|\n|106|\n 108|wf2huxig|frank|8/18/15|west london|g|36000.29|109|1 109|_hunter2|alice|8/30/15|\n|g|38987.82|108|1 110|fd9qpkoa|waldo|3/22/2016|scotland|g|7450004|\n|0 111|fd9qpkov|albus|02/22/2016|highlands, scotland|g|745697.54|\n|0 112|xzgsvzld|bill|7/4/16|charing cross road, london|g|55564.55|\n|1 113|00zn7h5f|neville|7/4/15|\n||23455|114|1 114|y8zui9ez|luna|01/22/2016|devon, england|h|9823.67|113|1 115|3wffg2im|malfoy|07/27/2015|wiltshire, england|u|32221223.88|\n|1 116|jrmiaa3n|ginny|06/29/2015|ottery st catchpole, devon|u|194649|125|1 117|gdybr39p|fred|01/31/2015|\n|l|3444334.78|\n|0 118|xezjcii2|george|09/18/2015|london|l|3534498.45|\n|1 119|krzts0wq|peter|09/27/2016|edinburgh, scotland|\n|5004|\n|0 120|jatv6mn9|petunia|01/16/2016|4 privet drive, surrey|u|9563.77|124|1 121|paxeeher|argus|4/3/15|highlands, scotland|l|29043.37|\n|1 122|taje9hrc|seamus|2/2/15|kenmare, county kerry|h|54290.7|\n|1 123|q9hy22hh|cho|\n|\n|h|4323646|\n|\n 124|xl3qpmmw|vernon|2/6/15|4 privet drive, surrey|u|55838.6|120|1 125|l0goxkmb|harry|04/21/2015|west country, england|g|\n|116|1 126|gy6x9kid|voldemort|3/8/15|london|h|85387800.89|\n|0 127|2qx5k5q9|ron|12/1/16|\n|u|74690.43|\n|1 \.