Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
|
Depends of the db used.
If mysql, then this is how:
Code:
create table if not exists random (
id int auto_increment,
nbr int,
primary key (id)
);
truncate table random;
create temporary table if not exists cr1 (
nbr int
);
truncate table cr1;
create temporary table if not exists cr2 (
nbr int
);
truncate table cr2;
create temporary table if not exists cr3 (
nbr int
);
truncate table cr3;
/*We use those to generate entries*/
insert into cr1 (nbr) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(0);
insert into cr2 (nbr) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(0);
insert into cr3 (nbr) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(0);
/*Create those entries in the table*/
insert into random (nbr)
select 1
from cr1
cross join cr2
cross join cr3
;
/*Assign a random number between 5000 and 10000*/
update random
set nbr=FLOOR(5000 + (RAND() * 10000));
/*And voila...*/
SELECT *
from random;
Of course, skip to the update if you don't need to generate the datas.
__________________
Only a biker knows why a dog sticks his head out the window.
Last edited by tripy; 02-02-2010 at 07:28 AM..
|