# MySQL利用变量进行查询操作
set@cityName='Haarlemmermeer';
select * from city where `Name`=@cityName;
# 多个结果查询
set @cityNames='Haarlemmermeer,Breda,Willemstad';
select @cityNames;
select * from city where `Name` in (@CityNames);
#错误!!把cityNames看成了整体,下面为正确形式
set @cityName1='Haarlemmermeer';
set @cityName2='Breda';
set @cityName3='Willemstad';
select * from city where `Name` in (@cityName1,@cityName2,@cityName3);
MySQL利用变量进行查询操作
最新推荐文章于 2024-08-12 23:11:19 发布