变名.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 17 行

----空洞形成！
create table test_1(name varchar(100));
insert into test_1 values('1');
insert into test_1 values('2');
insert into test_1 values('3');
insert into test_1 values('4');

select rowid ,name form test_1;

delete from test_1 where name='2';

insert into test_1 values('1234567890');
select rowid ,name from test_1;

 create table test2 as select name clo1 from test_1;