插入CSV文件mysql有日期时间错误

Question

我正试图将csv文件插入mysql，但我在datetime字段中有错误。我尝试了这个，但收到这个错误在这一行.....日期，时间= startdatetime.split('/')ValueError:需要多于1个值来解包mycsv文件，行如下:

2880,HY13KZV,2014/07/07 09:34:28,2014/07/08 09:34:28,1280
2880,RK09UZB,2014/07/07 10:34:05,2014/07/07 16:34:05,640
for row in reader:
                print row
                try:
                    (machine_name,vrm,startdatetime,enddatetime,ticket_price) = [x.decode('utf-8-sig') for x in row]
                except:
                    print "Error with row: " % row
                tmp = startdatetime.split(" ")
                tmp = enddatetime.split(" ")
                vrm = vrm.replace(' ','')
                vrm = vrm.upper()
                ticket_price = int( SessionCost / 100)
                date,time  = startdatetime.split('/')
                month,day,year = startdate.split('/')
                entryDatetime = "%s-%s-%s %s" % (year,month,day,time)
                date,time = enddatetime.split('/')
                month,day,year = enddate.split('/')
                expiryDatetime = "%s-%s-%s %s" % (year,month,day,time)
                sql_local = """INSERT INTO customer_1.pay_and_display
                    (plate, machine_id, ticket_datetime, expiry_datetime, ticket_name, ticket_price)
                    VALUES ("%s", "%s", "%s", "%s", "%s", "%s") """ % (vrm, machine_name, entryDatetime, expiryDatetime, "Ringo", SessionCost)
            print sql_local
            cursor.execute(sql_local)
            curl = pycurl.Curl()
            body = Body()

Answer 1

你的问题是在"/"上分裂出3个字段

year,month,day  = startdatetime.split('/')

实际上还有更多的错误。在

的位置使用以下代码

date,time = startdatetime.split(' ')
year,month,day = date.split('/')
hour,min,second = time.split(':')