最后,存储过程是解决我的问题的方法。这是有帮助的:
DELIMITER //CREATE PROCEDURE test () BEGIN DECLARE myvar DOUBLE; SELECt somevalue INTO myvar FROM mytable WHERe uid=1; SELECT myvar; END //DELIMITER ;call test ();

最后,存储过程是解决我的问题的方法。这是有帮助的:
DELIMITER //CREATE PROCEDURE test () BEGIN DECLARE myvar DOUBLE; SELECt somevalue INTO myvar FROM mytable WHERe uid=1; SELECT myvar; END //DELIMITER ;call test ();