xiyue613的博客

alter table fxown_house add column create_time datetime not null comment '创建时间';alter table house_ledger drop disaster_type, DROP disaster_date;alter table house_ledger modify column disaster_event bigint NOT NULL COMMENT '灾害事件ID';UPDATE support_netraf.

CREATE TABLE `edata` ( `DATA_ID` bigint NOT NULL AUTO_INCREMENT COMMENT '数据ID', `EVENT_ID` bigint DEFAULT NULL COMMENT '事件ID', `SURVEY_DIRECTORY` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调查报告目录', `SURVEY_CONTENT` longtext CHAR...

DELETEFROM house_damage_ledgerWHERE (area_code, household_head_id) IN ( SELECT t.area_code, t.household_head_id FROM ( SELECT area_code, household_head_id ...

先加条件，再从搜索结果group bySELECT * FROM house_damage_ledgerWHERE household_head_id in(SELECT household_head_id FROM (SELECT household_head_id, area_code, to_char(disaster_date,'yyyy') as ye FROM house_damage_ledgerWHERE ye >= '2014' and ye <= '...

select LEGAL_ID as id, name as title,1 as type from rl WHERE name like '%法%'union allselect MSDS_ID as id,name as title,2 as type from rs WHERE name like '%法%'union allselect STANDARD_ID as id,name as title,3 as type from rd WHERE name like '%法%'...

人大金仓 `NAME`, `STATUS` insert into sr ("NAME", "STATUS" mysql `NAME`, `TYPE` insert into rd (STANDARD_NUMBER, `NAME`, `TYPE`,