康师傅架构学习之路

大多数情况下，并不会采用在线直接设计表结构，大多时候是使用工具设计，然后导入系统当前的online 并不支持直接转化为table_comment ，即默认了table_nameupdate claimbyself.onl_cgform_head ,(select * from information_schema.TABLES where table_schema='你的表名') name set table_txt = name.table_comment where onl_cgform_he

SELECT a.table_name,b.TABLE_COMMENT,a.COLUMN_NAME,a.COLUMN_TYPE,a.COLUMN_COMMENT FROM information_schema.columns a JOIN information_schema.TABLES b ON a.TABLE_SCHEMA =b.TABLE_SCHEMA AND a.TABLE_NAME =

select * from (select  row_number() over(partition by vjp   order by id desc ) a  ,e.* from     COOL_TBL_CHAIN_ENVIRON e) a where a.a =1分组取 第一条 select  row_number() over(partition by

SELECT *  FROM information_schema.columns a JOIN  information_schema.TABLES b ON a.table_schema=b.table_schema AND a.table_name =b.table_name WHERE a.table_name IN( SELECT TABLE_NAME FROM TABLES WHERE