可以的,不过不晓得 你 赋 什么样的值,赋的值有规律么?
追问随便赋,比如递增的数字,从1到100
追答create sequence sequence_aotuincrement
start with 1 --设定起始值
increment by 1 --设定递增值
maxvalue 999999999 --设定最大值
create table temp as select *,sequence_aotuincrement.next from 表名 ;
drop table 表名;
alter table temp rename to 表名
追问我是小白- -‘’,请问,"sql语句未正确结束",这个要怎么结束呢?
追答以 英文分号结束;
追问![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/64380cd7912397dd79fc3dba5a82b2b7d1a28783?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd114031d79eba12c8fcc2ce2d8c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
改了英文分号了,然后还是这个样子。。。。。
我不懂怎样让加到这里面去
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9691593673a01213fb80e9150?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追答-- 先备份op_zhangyue_emp 表
create sequence sequence_aotuincrement
start with 1 --设定起始值
increment by 1 --设定递增值
maxvalue 999999999; --设定最大值
create table temp_auto as select a.*,sequence_aotuincrement.next from op_zhangyue_emp a;
drop table op_zhangyue_emp;
alter table temp_auto rename to op_zhangyue_emp ;