这样写就会报typeError错误
sql = "SELECT * FROM pas_app_inout_plan WHERE departure_train_code = '%s' AND station_name = '%s' and DATE_FORMAT(arrival_time,'%%Y-%%m-%%d') like '%s' ORDER BY arrival_time DESC"%input7.get()%input6.get()%input9.get()
给参数改成%(,,)的形式就不会报错了,这个原因还没搞明白,希望有大神给解惑下啊
sql = "SELECT * FROM pas_app_inout_plan WHERE departure_train_code = '%s' AND station_name = '%s' and DATE_FORMAT(arrival_time,'%%Y-%%m-%%d') like '%s' ORDER BY arrival_time DESC"%(input7.get(),input6.get(),input9.get())