展开全部
可以的。
1)创建测试会用的环境创建测试db
create database if not exists demo;
use demo;
分别创建表
drop table pet;
create table pet(
id int,
name varchar(20)
);
alter table pet add primary key(id);
delimiter //
drop procedure if exists per2;
create procedure per2()
begin
declare num int;
set num=1;
while num
insert into pet values(num,'test');
set num=num+1;
end while;
end
//
DELIMITER ;
call per2();
drop table pet2;
create table pet2(
id int,
value int
);
alter table pet2 add primary key(id);
delimiter //
drop procedure if exists per3;
create procedure per3()
begin
declare num int;
set num=1;
while num
insert into pet2 values(num,FLOOR(RAND() * 100));
set num=num+1;
end while;
end
//
DELIMITER ;
call per3();
2)测试mysql> select t.id as IDA,t.name as NameA from demo.pet t where t.id <10;
+-----+-------+
|e69da5e6ba9062616964757a686964616f31333365633934 IDA | NameA |
+-----+-------+
| 1 | test |
| 2 | test |
| 3 | test |
| 4 | test |
| 5 | test |
| 6 | test |
| 7 | test |
| 8 | test |
| 9 | test |
+-----+-------+
9 rows in set (0.00 sec)
mysql> select p.id as IDA,p.value as ValueA from demo.pet2 p where p.id <10;
+-----+--------+
| IDA | ValueA |
+-----+--------+
| 1 | 50 |
| 2 | 50 |
| 3 | 2 |
| 4 | 57 |
| 5 | 83 |
| 6 | 42 |
| 7 | 64 |
| 8 | 92 |
| 9 | 70 |
+-----+--------+
9 rows in set (0.00 sec)
mysql> select t.id as IDA,t.name as NameA,p.value as ValueA from
demo.pet t, demo.pet2 p
where t.id <10 and t.id=p.id;
+-----+-------+--------+
| IDA | NameA | ValueA |
+-----+-------+--------+
| 1 | test | 50 |
| 2 | test | 50 |
| 3 | test | 2 |
| 4 | test | 57 |
| 5 | test | 83 |
| 6 | test | 42 |
| 7 | test | 64 |
| 8 | test | 92 |
| 9 | test | 70 |
+-----+-------+--------+
9 rows in set (0.00 sec)