注册

寻求部分Mysql函数替代函数

珈蓝 2021/12/24 1335 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:linux7.4
【CPU】:常见cpu非国产化cpu
【问题描述】*:寻求部分mysql替代函数,或者相关集成方案

对接代码自动生成需要用到几个函数

  1. select column_name, (case when (is_nullable = ‘no’ <![CDATA[ && ]]> column_key != ‘PRI’) then ‘1’ else null end) as is_required, (case when column_key = ‘PRI’ then ‘1’ else ‘0’ end) as is_pk, ordinal_position as sort, column_comment, (case when extra = ‘auto_increment’ then ‘1’ else ‘0’ end) as is_increment, column_type
    from information_schema.columns where table_schema = (select database()) and table_name = (#{tableName})
回答 0
暂无回答
扫一扫
联系客服