Mysql - 打印@loop_start_date到@loop_end_date之间的所有值

Question

我正在尝试:

1. 打印@loop_start_date到@loop_end_date之间的所有值
2. loop_start_date 应在此处增加 1，直到 loop_start_date=loop_end_date

我尝试了下面，但 Mysql 说

     #1064 - You have an error in your SQL syntax; check the manual that 
        corresponds to your MySQL server version for the right
 syntax to use near 'BEGIN   Declare @user_id int' at line 3

这是程序代码

CREATE PROCEDURE generatePayscale

BEGIN
    Declare @user_id int;
    Declare @office_id int;
    Declare @loop_start_date Date;
    Declare @loop_end_date Date;
    SET @user_id = 1287;
    SET @office_id = 8;
    SET @loop_start_date = '2018-06-02'; 
    SET @loop_end_date = '2018-06-06';


    WHILE(@loop_start_date < @loop_end_date) do 
        SELECT old_paysetupid 
        FROM   personneltransfer personnelid=@user_id 
        AND    pt.transferdate>@loop_start_date 
    END WHILE;
 END

Answer 1

这可能会为您指明正确的方向，我会改变一些事情。添加了BEGIN。然后为每个变量添加声明。然后你需要在 from 后面加上 where

SET @user_id = 1287;
SET @office_id = 8;
SET @loop_start_date = '2018-06-02'; 
SET @loop_end_date = '2018-06-06';

WHILE(@loop_start_date < @loop_end_date) do
BEGIN 
    SELECT old_paysetupid 
    FROM   personneltransfer where personnelid=@user_id 
    and pt.transferdate>@loop_start_date 
END WHILE;