blob: 630c5285d09e74803942ee1e00e6b93a3e2c358a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
|
USE plato;
$input = select key, some(subkey) as subkey, some(value) as value from Input group by key;
select key from $input where subkey > "0"
order by key;
insert into @a
select t.*, RandomNumber(TableRow()) as rnd from $input as t where value > "a";
insert into @b
select * from $input;
|
