mysql-存储过程-插入数据数-测试在select语句中in和or的区别

drop table if exists test_1;
CREATE TABLE `test_1` (
  `v1` int(11) NOT NULL AUTO_INCREMENT,
  `v2` int(11) DEFAULT NULL,
  PRIMARY KEY (`v1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

create procedure sp_name()
begin
declare v int default 0;
declare tmp int default 0;
while v < 5000000
do
set tmp=floor(rand()*100);
insert into  test_1(v1,v2)
values ('',tmp);
set v = v + 1;
end while;
end

SELECT * FROM test_1 where v2 in(51,42,33,24,65,76,87,98,9,11,12,13,14,15);
SELECT * FROM test_1 where v2=51 or v2=42 or v2=33 or v2=24 or v2=65 or v2=76 or v2=87 or v2=98 or v2=9 or v2=11 or v2=12 or v2=13 or v2=14 or v2=15;