1、不支持count(distinct if(xxx,x,x)),可考虑转写为count(distinct case when xxx);
2、update_at等表的时间戳字段,需要加触发器才能自动更新,否则不会;
3、python连接数据库:达梦不带database参数,需要添加schema参数;
cfg_base = BaseConfig
conn = dmPython.connect(
host=cfg_base.DM_HOST,
port=cfg_base.DM_PORT,
user=cfg_base.DM_USERNAME,
password=cfg_base.DM_PASSWORD,
schema=cfg_base.DM_DATABASE)
conn = pymysql.connect(
host=cfg_base.MYSQL_HOST,
port=cfg_base.MYSQL_PORT,
user=cfg_base.MYSQL_USERNAME,
password=cfg_base.MYSQL_PASSWORD,
database=cfg_base.MYSQL_DATABASE)