sql用法
修改表中某个字段类型
alter table s_person modify column id bigint(20) not null;
修改表中某个字段长度(注:主键ID不能修改)
alter table S_ATTACHMENT alter column FILE_NAME varchar(800);
修改字段的值(替换原值、在原值前或后拼接)
update country set chinese='中国' where english='China';
update i18n set code = concat ('ios_',code) where id=512226;
备份表/复制表
create table tea_bak (as) select * from tea;(适用于oracle/mysql)
insert into tea select * from tea_bak
select * into tea_bak from tea;(适用于sqlserver)
查询国家表中编码值相同且大于1的国家信息
select * from country where nation_code in
(select nation_code from country group by nation_code having count(*)>1);