pymysql 向mysql 插入json 数据

Question

json_campaign={"download":day_download,"cost":day_cost,"budget":day_budget}
                        data_json=data_json = json.dumps(json_campaign)
                       
                        id2="insert into oppo_cpd_stat_total_list (account_id,campaign_id,campaign_name, json_campaign)values('%s','%s','%s','%s');"%(account_id,campaign_id,campaign_name,data_json)
                        
                        
 
 

向mysql 插入json 数据

 这样写对吗？