mysql 删除最后一行

DELETE FROM your_table
ORDER BY your_id DESC
LIMIT 1;

DELETE FROM your_table
WHERE your_id = (SELECT your_id FROM your_table ORDER BY your_id DESC LIMIT 1);

DELIMITER //

CREATE PROCEDURE delete_last_row()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE last_id INT;
    DECLARE cur CURSOR FOR SELECT your_id FROM your_table ORDER BY your_id DESC LIMIT 1;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO last_id;
        IF done THEN
            LEAVE read_loop;
        END IF;
        DELETE FROM your_table WHERE your_id = last_id;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL delete_last_row();

ALTER TABLE your_table DROP FOREIGN KEY your_foreign_key;

ALTER TABLE your_table DROP INDEX your_index;
ALTER TABLE your_table ADD INDEX (your_column);