CREATE TEMPORARY TABLE MMM (material_id varchar (255));
CREATE TEMPORARY TABLE tem (id varchar (255), the time a datetime, weight float, price float, total_price float, the type int, stock_total_m float, stock_total_w float, create_date varchar (255))


Insert into MMM values
Select the id from t_comm_material where id in (' 8 adee284554cb68301556c8bec232743 ',

CodePudding user response:

CodePudding user response:

Insert into MMM values
Select the id from t_comm_material where id

Remove the values, use the select result set, in front of the insert statement, not values

CodePudding user response:

Then ask a question, is essentially in
While exist (select * from A)
The begin

How do you use the end in mysql

CodePudding user response:

reference qq_35197601 reply: 3/f

to ask a question, is essentially in
While exist (select * from A)
The begin

End in mysql about how to use

You want to realize in the process of storage, or in the anonymous block to realize?

CodePudding user response:

Inside a stored procedure

CodePudding user response:

reference 4 floor wmxcn2000 response:

Quote: reference qq_35197601 reply: 3/f

Then ask a question, is essentially in
While exist (select * from A)
The begin

End in mysql about how to use

You want to realize in the process of storage, or in the anonymous block to realize?

While the exists (select * from MMM)

CodePudding user response: