MYSQL利用变量进行查询操作
#MYSQL利用变量进行查询操作
set @cityName='Haarlemmermeer';
SELECT * FROM city where `Name`=@cityName;
#多个查询结果
set @cityNames='Haarlemmermeer,Breda,Willemstad';
SELECT @cityNames;
SELECT * FROM city where `Name` in (@cityNames);
SET @cityName1='Haarlemmermeer';
SET @cityName2='Breda';
SET @cityName3='Willemstad';
SELECT * FROM city WHERE `Name` IN (@cityName1,@cityName2,@cityName3);