随笔分类 -  DataBase

摘要:内置函数相互转换: SELECT TO_DAYS('2021-01-01'); SELECT FROM_DAYS(738162); 创建分区表示例 CREATE TABLE IF NOT EXISTS `{tb_name}` ( `id` int(11) NOT NULL AUTO_INCREMEN 阅读全文
posted @ 2021-01-07 16:55 士为知己 阅读(553) 评论(0) 推荐(0)
摘要:查询分区表 SELECT nmsp_parent.nspname AS parent_schema, parent.relname AS parent, nmsp_child.nspname AS child_schema, child.relname AS child, child.oid AS 阅读全文
posted @ 2021-01-07 15:52 士为知己 阅读(3507) 评论(0) 推荐(0)
摘要:import pymysql import psycopg2.extras import pymssql import logging class DBMS(object): """ The context manager has been implemented, Can be modified 阅读全文
posted @ 2021-01-06 17:08 士为知己 阅读(121) 评论(0) 推荐(0)