Python 字符串 替换符 占位符

SQL = "INSERT into experimentdata(pid, uploader, uploadstartdate,uploadenddate,experimentdate,datanum,datadescribe,dealtimes) values (%(pid)d,%(uploader)d,'%(uploadstartdate)s','%(uploadenddate)s','%(experimentdate)s','%(datanum)s','%(datadescribe)s',%(dealtimes)d);"%{'pid':pid,'uploader':uploader,'uploadstartdate':uploadstartdate,'uploadenddate':uploadenddate,'experimentdate':experimentdate,'datanum':datanum,'datadescribe':datadescribe,'dealtimes':dealtimes}

 

 

字符串占位符