#MYSQL利用变量进行查询
set @cityName='Harrlemmermeer';
SELECT * from city where `Name`=@cityName;
#多个结果查询
set @cityNames='Harrlemmermeer,Breda,Willemstad';
SELECT @cityNames;
SELECT * from city where `Name` in (@cityNames);
set @cityName1='Harrlemmermeer';
set @cityName2='Breda';
set @cityName3='Willemstad';
SELECT * from city where `Name` in (@cityName1,@cityName2,@cityName3);
MYSQL利用变量进行查询操作
最新推荐文章于 2024-07-26 14:20:58 发布