用MySQL8.0写代码，表stock_k_data AS T1 中字段有 ID,open, high, low, close,price,status用游标形式循环逐行计算， T1.字段名表示当前行，T2.字段名表示上一行， t1.ID= 2，循环到最后一行 ， IF t2.status = "买入" AND t1.low<T2.price*0.95,THEN SET t1.status="卖出", t1.price=T2.price*0.95 IF t2.status = "买入" ,THEN t1.status="持有",t1.price=GREATEST(T2.price,T1.high) ELSEIF t2.status= "持有" AND t1.low<GREATEST(T2.price,T1.high)*0.95 ,THEN t1.status="卖出",t1.price=GREATEST(T2.price,T1.high)*0.95 ELSEIF t2.status= "持有" ,THEN t1.status="持有", t1.price=GREATEST(T2.price,T1.high) ELSEIF t2.status = "卖出" AND t1.high>T2.price*1.05,THEN t1.status="买入", t1.price=T2.price*1.05 ELSEIF t2.status = "卖出" ,THEN t1.status="空仓", t1.price=LEAST(T2.price,low) ELSEIF t2.status = "空仓" AND t1.high>LEAST(T2.price,low)*1.05,THEN t1.status="买入", t1.price=LEAST(T2.price,low)*1.05 ELSEIF t2.status = "卖出" ,THEN t1.status="空仓", t1.price=LEAST(T2.price,low) ENDIF

好的，下面是用MySQL8.0实现上述功能的代码：

DECLARE done INT DEFAULT FALSE;
DECLARE cur_id INT;
DECLARE cur_open FLOAT;
DECLARE cur_high FLOAT;
DECLARE cur_low FLOAT;
DECLARE cur_close FLOAT;
DECLARE cur_price FLOAT;
DECLARE cur_status VARCHAR(10);
DECLARE prev_id INT;
DECLARE prev_open FLOAT;
DECLARE prev_high FLOAT;
DECLARE prev_low FLOAT;
DECLARE prev_close FLOAT;
DECLARE prev_price FLOAT;
DECLARE prev_status VARCHAR(10);

DECLARE cur CURSOR FOR SELECT ID, open, high, low, close, price, status FROM stock_k_data WHERE ID >= 2 ORDER BY ID ASC;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

OPEN cur;

FETCH cur INTO cur_id, cur_open, cur_high, cur_low, cur_close, cur_price, cur_status;

WHILE NOT done DO
    IF prev_status = "买入" AND cur_low < prev_price * 0.95 THEN
        SET cur_status = "卖出", cur_price = prev_price * 0.95;
    ELSEIF prev_status = "买入" THEN
        SET cur_status = "持有", cur_price = GREATEST(prev_price, cur_high);
    ELSEIF prev_status = "持有" AND cur_low < GREATEST(prev_price, cur_high) * 0.95 THEN
        SET cur_status = "卖出", cur_price = GREATEST(prev_price, cur_high) * 0.95;
    ELSEIF prev_status = "持有" THEN
        SET cur_status = "持有", cur_price = GREATEST(prev_price, cur_high);
    ELSEIF prev_status = "卖出" AND cur_high > prev_price * 1.05 THEN
        SET cur_status = "买入", cur_price = prev_price * 1.05;
    ELSEIF prev_status = "卖出" THEN
        SET cur_status = "空仓", cur_price = LEAST(prev_price, cur_low);
    ELSEIF prev_status = "空仓" AND cur_high > LEAST(prev_price, cur_low) * 1.05 THEN
        SET cur_status = "买入", cur_price = LEAST(prev_price, cur_low) * 1.05;
    ELSEIF prev_status = "空仓" THEN
        SET cur_status = "空仓", cur_price = LEAST(prev_price, cur_low);
    END IF;

    UPDATE stock_k_data SET status = cur_status, price = cur_price WHERE ID = cur_id;

    SET prev_id = cur_id, prev_open = cur_open, prev_high = cur_high, prev_low = cur_low, prev_close = cur_close, prev_price = cur_price, prev_status = cur_status;

    FETCH cur INTO cur_id, cur_open, cur_high, cur_low, cur_close, cur_price, cur_status;
END WHILE;

CLOSE cur;

该代码通过游标形式循环逐行计算表stock_k_data的数据，并按照给定的条件更新状态和价格。其中，使用了IF-ELSEIF-ELSE语句对不同的状态进行判断和处理。在每次更新完当前行的数据后，将当前行的数据赋值给prev_XXX变量，作为下一次循环时的上一行数据。最后，关闭游标。