django导入mysql_django如何直接对数据库进行插入操作?

通过psycopg2与数据库进行连接,发现可以进行查询操作:

sql = """select * from oms.cus_questions WHERE que_no = '20170606174216'"""

查询到的结果:

[['20170606174216', '1000', '1220', None, None, None, '1002', None, None, None, '提现到账查询', '未到账', None, None, None, None, False, datetime.datetime(2017, 6, 6, 17, 42, 7, 7293, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=480, name=None)), None, datetime.datetime(2017, 6, 6, 17, 42, 7, 7293, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=480, name=None)), None]]

修改主键值,将上面查询的结果,再次插入数据库,修改sql:

sql = """insert into oms.cus_questions("que_no", "loan_no", "usr_id", "phone_no", "ctif_id_no", "usr_name", "que_type", "que_status", "flow_no", "do_usr_id", "que_title", "que_description", "que_solution", "que_doing_tm", "crt_done_tm", "que_ower_id", "is_deleted", "crt_tm", "crt_usr", "last_upd_tm", "last_upd_usr") values('20170606174216', '1000', '1220', None, None, None, '1002', None, None, None, '提现到账查询', '未到账', None, None, None, None, False, datetime.datetime(2017, 6, 6, 17, 42, 7, 7293, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=480, name=None)), None, datetime.datetime(2017, 6, 6, 17, 42, 7, 7293, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=480, name=None)), None) """

报错:

psycopg2.ProgrammingError: 错误: 字段 "none" 不存在

LINE 1: ...d_usr") VALUES ('20270606174216', '1000', '1220', None, None...

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值