psycopg2.ProgrammingError: column "hamilton" does not exist LINE 4: values(660,233,
代码:这是正确代码
_insert_query = ''' insert into trend( new_listings,homes_sold,average_days_on_market,selling_to_listing_price_ratio,city) values(%s,%s,%s,%s,'%s') '''%(item['new_listings'],item['homes_sold'],item['average_days_on_market'],item['selling_to_listing_price_ratio'] ,str(item['city']))
错误代码:
_insert_query = ''' insert into trend( new_listings,homes_sold,average_days_on_market,selling_to_listing_price_ratio,city) values(%s,%s,%s,%s,%s) '''%(item['new_listings'],item['homes_sold'],item['average_days_on_market'],item['selling_to_listing_price_ratio'] ,str(item['city']))
对于字符数据需要加引号;
这个很奇怪,为什么在mysql中就没有问题;