I want to give A clob fields inside insert A lot of A user id, here refers to the number, such as one-time select I checked 1000 users, how to put these id inserted into the field, I write the insert into A (clob) values (select userid from user) tips I lack of expression, is the need to write A stored procedure

CodePudding user response:

The first in more than 1000 ID joining together into one big string, again to write in table A,

CodePudding user response:

Too many grammar mistake, give you a lazy writing

The create table test_190219 clob (aaa);
Insert into test_190219 select wm_concat (userid) from the user;
Drop table test_190219;

CodePudding user response:

Two eldest brother trouble careful have a look at my question, and let me put 1000 Mosaic of the string, that I ask this do, 10000 I also manually spell?

CodePudding user response:

You have pieced together, otherwise is 1000 lines, cannot hope to a data in it,

CodePudding user response:

Insert into A (clob) values (select userid from user)
Change
Insert into A (clob) select userid from user

CodePudding user response:

Syntax error, it should be
Insert into A (clob) select userid from the user;