qq_37978725的博客

SELECT COLUMN_NAME 列名, COLUMN_COMMENT 备注, COLUMN_TYPE 数据类型, DATA_TYPE 字段类型, CHARACTER_MAXIMUM_LENGTH 长度, IS_NULLABLE 是否为空, COLUMN_DEFAULT 默认值 FROM information_schema. COLUMNS WHERE TABLE_NAME = 'base_unit' AND TABLE_SCH...

BEGIN -- 定义变量 DECLARE strModifier varchar(255); DECLARE strModifyIdCard varchar(255); DECLARE strModifyPhoneNum varchar(255); DECLARE strModifyUnit varchar(256); DECLARE strModifyIdentity varchar(256); DECLARE done INT DEFAULT...

原sql 与inner join组合使用会造成，数据不一致 改造写法，改造为子查询GROUP_CONCAT SELECT `bhu`.`strUserGuid` AS `strGuid`, `bhu`.`strArea` AS `strArea` FROM ( `household_user` `hu` JOIN ( SELECT ( SELECT GROUP_CONCAT(DISTINCT keypropCode SEPARATOR ',' ) FROM household_user_k.