mysqldump -uroot -p --no-create-info --no-create-db hawa_new scada_data wind_turbine "SELECT s.* FROMscada_data as s,wind_turbine as w WHERE s.local_tm BETWEEN '2018-02-01' AND '2018-02-28' AND s.turbine= w.id AND w.pooling_station = 29" |gzip > &
我在从MySQL游标取值时遇到问题。我创建了一个临时表,它仅仅是另一个表的副本(原始表有一个变量名,它是作为过程的参数传递的,因为MySQL不支持变量表名,所以我必须创建一个副本--不能直接使用原表)。double;
DECLARE iter CURSOR FOR (SELECT id,cape,rain,snow,hstones,clouds,raining,wind_u,wind_v FROM temp_tbl);
DECLARE CONTINUE HANDLER FOR