Mysql 设置变量的几种方式

1. 
  SET @Template_Title_L=(SELECT Title FROM AA WHERE ID=1);  
2. 
  DECLARE Article_Title_L VARCHAR(1000);   
  DECLARE Article_URL_L VARCHAR(1000); 
  SELECT IFNULL(Article_Title,''),IFNULL(Article_URL,'')
  INTO Article_Title_L, Article_URL_L
  FROM article_detail WHERE article_detail_id =Article_Detail_ID_In;
3. SELECT @Title:=Title FROM AA WHERE ID=1