bdb-alter-table-1.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:0k
源码类别:
MySQL数据库
开发平台:
Visual C++
- drop table if exists t1;
- create table t1(objid BIGINT not null, tablename varchar(64), oid BIGINT not null, test BIGINT, PRIMARY KEY (objid), UNIQUE(tablename)) engine=BDB;
- insert into t1 values(1, 't1',4,9);
- insert into t1 values(2, 'metatable',1,9);
- insert into t1 values(3, 'metaindex',1,9 );
- select * from t1;
- objid tablename oid test
- 1 t1 4 9
- 2 metatable 1 9
- 3 metaindex 1 9
- alter table t1 drop column test;