--备份表a
create table a_backup as select * from a;
--去前置0
SELECT trim(leading'0' from 0001);
--给表添加一列
alter table a add colums varchar(100);
--给某列插入数据
UPDATE qs_sap_area_anna set LIFNR_TRIM=trim(leading '0' from LIFNR);
--匹配纯数字
SELECT * from qs_sap_area_anna
where NAME1 regexp '[0-9]' and char_length(NAME1)=1;
--匹配特殊字符
SELECT NAME1 from qs_sap_area_anna
where NAME1 regexp '[~!@#\$%^&*{}|<>",.;+]';
--两个字段都重复
SELECT bankl,bankn,count(1) from qs_sap_bank_anna
group by 1,2
having count(1)>1;
--查询字段不同长度的数量
SELECT LENGTH(bankn),count(1) from qs_sap_bank_anna
group by 1
having count(1)>1;
--创建索引
create index indxname on tabname;
--删除索引
drop index indxname;
--创建视图
create view viewname as select statement
--给字段添加注释
create table a
(MANDT char(3) comment "客户端");
create table a_backup as select * from a;
--去前置0
SELECT trim(leading'0' from 0001);
--给表添加一列
alter table a add colums varchar(100);
--给某列插入数据
UPDATE qs_sap_area_anna set LIFNR_TRIM=trim(leading '0' from LIFNR);
--匹配纯数字
SELECT * from qs_sap_area_anna
where NAME1 regexp '[0-9]' and char_length(NAME1)=1;
--匹配特殊字符
SELECT NAME1 from qs_sap_area_anna
where NAME1 regexp '[~!@#\$%^&*{}|<>",.;+]';
--两个字段都重复
SELECT bankl,bankn,count(1) from qs_sap_bank_anna
group by 1,2
having count(1)>1;
--查询字段不同长度的数量
SELECT LENGTH(bankn),count(1) from qs_sap_bank_anna
group by 1
having count(1)>1;
--创建索引
create index indxname on tabname;
--删除索引
drop index indxname;
--创建视图
create view viewname as select statement
--给字段添加注释
create table a
(MANDT char(3) comment "客户端");