1 create a trigger, when changes to the place in the table, the corresponding modify the ranking results, the first named eight points, the second is called 7 points,... Eighth, 1 minute,

2 create a stored procedure, the input parameters for athletes number, output parameters for field events the athletes score

3
Create functions, parameters for "group number", the return value for the group's score,

4 create native user "user1", the password for your student id, this papers to the function of the execute permissions (without permission, please make your own added), and log in the user, perform the function in this paper,

5 using the mysqldump command, save the entire library, and then delete a tuple, reusing previous backup recovery,

Bosses help ah, I can write how much will do

CodePudding user response:

Top, is there a big help, have to do is to write about two or three questions??

CodePudding user response:

Top, is there a big help, have to do is to write about two or three questions??

CodePudding user response:

Please provide the table structure and fields.