执行过程报错

[jkjay]

DELIMITER $$



DROP PROCEDURE IF EXISTS `up_ihotel_xhj_ihotel`$$

CREATE DEFINER=`root`@`%` PROCEDURE `up_ihotel_xhj_ihotel`() 

BEGIN


  DECLARE day1 INT;
  DECLARE count1 INT;
  DECLARE date1 DATETIME;
  
  CREATE TEMPORARY TABLE IF NOT EXISTS tmpTable(
  date1  DATETIME NOT NULL,
  count1 INT,
  PRIMARY KEY (date1)
   );
   
   SET count1=0;
  SET day1 =DATEDIFF((SELECT create_datetime FROM card_base ORDER BY create_datetime ASC  LIMIT 1),NOW());
  
  SET date1 =NOW();

  WHILE(day1<>-1) DO
	  BEGIN
		  SET count1 =(SELECT COUNT(*) FROM card_base  WHERE  DATEDIFF(create_datetime,NOW())=day1)+count1;
		  INSERT INTO tmpTable SELECT (DATE_ADD(date1, INTERVAL -day1 DAY) ,count1);
		  SELECT day1 =day1-1;
	  END;
END WHILE;
  SELECT * FROM tmpTable;

   DROP TABLE tmpTable;

END$$
DELIMITER ;

执行过程Error Code : 1241
Operand should contain 1 column(s)
哪里sql写错额？

[jkjay]

不是oracle，是MYSQL么

[昵称被占用了]

这是什么的语法？

[xuam]

引用 1 楼 Haiwer 的回复:

这是什么的语法？

好像是orcale

[以学习为目的]

版主帮忙移到Oracle专区