For example a student final_list table have student id, name, score
Now for achievement anticipation, put those grades * 0.7 & lt; 35 people in fail_list table (student id, name, performance)
The remaining 0.7 * grades & gt;=30 into pass_list list
Then the rest into unknown_list table

CodePudding user response:

The best is a trigger type

CodePudding user response:

Don't use a stored procedure is a good solution

CodePudding user response:

is not insert data? Or to insert data into groups?

CodePudding user response:

The original poster is to want to do? If it is a show, when read out to make a judgment

CodePudding user response:

Select * into demo_tb from tb1 where performance * 0.7 & lt; 35