GBase 8a
运维管理
文章
同义词创建语法
发表于2025-06-25 14:55:5649次浏览2个评论
drop table if exists t1;
create table t1 (col1 int,col2 varchar(10));
insert into t1 values(1,'a');
select * from t1;
create synonym s1 for t1;
insert into s1 values(2,'b');
select * from s1;
update s1 set col2='aaa' where col1=1;
delete from s1 where col1=1;
select * from s1;
drop synonym s1;
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25044
- 42023-09-25浏览数:18519
- 52020-05-11浏览数:17526