set @cityName='Haar lemmermeer';
select * from city where `Name`=@cityName;
#多个结果查询
set @cityNames='Haar lemmermeer,Breda,Willemstad';
select @cityNames;
select * from city where `Name` in (@cityNames);
set @cityName1='Haar lemmermeer';
set @cityName2='Breda';
set @cityName3='Willemstad';
select * from city where `Name` in(@cityName1,@cityName2,@cityName3);
MySQ利用变量进行查询操作
于 2024-05-09 16:51:54 首次发布