1.建表:
CREATE TABLE PRO_STATEMENT
(
USERID NUMBER primary key ,
TRADECOUNT NUMBER(20),
TOTALAMT NUMBER(20),
COMMISION NUMBER(20),
STADATE VARCHAR2(20)
)
2.修改表中字段名称:
alter table RATE rename column PHONENO to USERID;
3.添加字段:
alter table bm_methods add sysdatestr varchar(40);