Can we WITH x AS ( ... ) INSERT INTO y(k) SELECT * FROM x in MySQL? We can do INSERT INTO SELECT, but what if I have a bunch of WITH AS statements (about 27ish) for the SELECT part? My current solution is do the query then scan using programming language (Golang for my case) then insert it using normal INSERT INTO statement one by one. Was there one step solution to do this?
Something like
insert into item
  with x as (    
    select id + 10 as id1, concat(brand,' D') as brand1 from item),
       y as (    
    select id + 20 as id1, concat(brand,' E') as brand1 from item)  
  select * from x   
  union all   
  select * from y

Yes, we can!