risingwave icon indicating copy to clipboard operation
risingwave copied to clipboard

Insert into part of columns

Open doki23 opened this issue 2 years ago • 1 comments

Is your feature request related to a problem? Please describe.

The column where you want to insert corresponding values. Currently, you must provide all columns in the table in order or leave this field empty.

As the doc saying, we can't insert part of columns of tables. It's a little bit inconvenient.

Describe the solution you'd like

support insert part of columns like

insert into table_a (col_0) values (0);

while table_a has col_1, col_2...

Describe alternatives you've considered

No response

Additional context

No response

doki23 avatar Sep 23 '22 06:09 doki23

Related: #4046

lmatz avatar Sep 23 '22 06:09 lmatz

duplicated https://github.com/risingwavelabs/risingwave/issues/4046

fuyufjh avatar Oct 25 '22 03:10 fuyufjh