如何从python向MYSQL中插入null decimals / datetime？

Question

我有数据文件：

'Laura', 'Laura Ellenburg', '5342 Picklied Trout Lane', 'Nashville', 'TN',
'38010','2000-02-22', ' ', '454-56-768'

注意末尾的‘’。

我使用的是python代码：

  data = []
  infile = open ("./BIGPVFC-ASC10e/Employee.asc", "r")
  for line in infile:
    line = line.rstrip("\n")
    line = line.strip()
    seq = line.split(", ")
    for i in range(0,9):
      seq[i] = seq[i].strip("'")
    seq = tuple (seq)
    data.append(seq)
  infile.close()

  cursor.executemany ("""insert into PV_employee
  (employeeid, employeename, employeeaddress, employeecity, employeestate,
   employeezip, employeedatehired, employeebirthdate, employeesupervisor)
   values (%s, %s, %s, %s, %s, %s, %s, %s, %s)""", data)

我的表格是：

create table PV_employee
 (employeeid         varchar(10)    not null
 ,employeename       varchar(25)    null
 ,employeeaddress    varchar(30)    null
 ,employeecity       varchar(20)    null
 ,employeestate      char(2)        null
 ,employeezip        varchar(10)         null  
 ,employeedatehired  datetime       null
 ,employeebirthdate  datetime      null
 ,employeesupervisor varchar(10)    null
 ,primary key (employeeid)
);

在那里我得到了错误“警告:超出列的范围值.....”

在小数为空的情况下，我得到“警告:不正确的小数值：‘’for column ...”

我已经尝试将' '更改为''、'NULL'和NULL。所有这些似乎都不起作用。有什么建议吗？

Answer 1

SQL的Python等效项是None。