文章分类 -  db

摘要:def get_insert_str(data_dict): key_str = ",".join(list(data_dict.keys())) print(key_str) value_str = ",".join(map(lambda x: "{}".format(x) if str(x).i 阅读全文
posted @ 2018-08-24 14:52 hyu9999
摘要:import osimport randomimport sys# 随机生成密匙random.randint(1, 255)_key = random.randint(1, 255)# 加密过的标示,两个字节have_encrypt_first_flag = 0x32have_encrypt_sec 阅读全文
posted @ 2017-11-21 15:22 hyu9999
摘要:#ALTER TABLE ###To add a column of type varchar to a table: ALTER TABLE distributors ADD COLUMN address varchar(30); ###To drop a column from a table: 阅读全文
posted @ 2017-11-02 11:22 hyu9999 阅读(267) 评论(0) 推荐(0)
摘要:ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] RENAME [ COLUMN ] column_name TO new_colum 阅读全文
posted @ 2017-11-02 10:46 hyu9999 阅读(171) 评论(0) 推荐(0)
摘要:原因分析: postgres主键排序是不同步 解决方案: 1.显示SQL更新应用程序MyApp的所有下一个ids: python manage.py sqlsequencereset MyApp2.执行该语句: python manage.py sqlsequencereset MyApp | py 阅读全文
posted @ 2017-08-22 12:06 hyu9999 阅读(1665) 评论(0) 推荐(0)