#MySQL利用变量进行查询操作
SET @cityName='Haarlemmermeer';
SELECT * FROM city WHERE 'Name'=@cityName;
#多个结果查询
SET @cityName='Haarlemmermeer,Zoetermeer,Emmen';
SELECT @cityNames;
SELECT * FROM city WHERE 'Name' in (@cityNames);
SET @cityName1='Haarlemmermeer';
SET @cityName2='Zoetermeer';
SET @cityName3='Emmen';
MySQL利用变量进行查询操作
最新推荐文章于 2024-07-19 10:05:15 发布