保存

db = MysqlHelper()

data = {"xxx": "123"}

db_data = json.dumps(data, ensure_ascii=False) 

print(db_data)

date_add = time.strftime("%Y-%m-%d", time.localtime())

sql ="INSERT INTO `table` ( `type_id`, `meta_key`, `meta_value`) VALUES ('%s', '%s', '%s');" % \

("xxxx", date_add, db_data)

db.insert(sql)

读取

db = MysqlHelper()

sql ="select *  from `table`"

res = db.select(sql)

for vin res:

    print(v["meta_value"])

    db_data = json.loads(v["xxxbb"])

    print(type(db_data))

    print(db_data['xxx'])