goInception icon indicating copy to clipboard operation
goInception copied to clipboard

不支持MySQL8.0的with语句

Open a516597993 opened this issue 7 months ago • 3 comments

create table t5 (id serial PRIMARY key,r1 int ,log_date datetime); insert t5 (r1,log_date) with recursive tmp(a,b) AS ( select 1, '2025-03-11' union all select round(rand()*10), date_add(b,interval 1 day) day from tmp limit 100 )table tmp;

with temp as ( select id from t5 WHERE id >50 ) update t5 join temp on t5.id=temp.id set t5.log_date=temp.log_date+1;

a516597993 avatar May 26 '25 03:05 a516597993

MySQL版本的Archery+goInception已经支持with as 语法,有需要的童鞋请+QQ327092839

duguwo avatar Jun 12 '25 01:06 duguwo

MySQL版本的Archery+goInception已经支持with as 语法,有需要的童鞋请+QQ327092839

可以合并到master分支吗

czxin788 avatar Jul 18 '25 08:07 czxin788

刚试了一下,下载这个goinception分支,就能支持 with as 语法了,感谢这个作者:https://gitee.com/zhoujin826/goInception

czxin788 avatar Jul 21 '25 07:07 czxin788