SEO

#1 (**permalink**) 02-28-2008, 09:42 AM

I want to generate a bunch (10000-100000) of sample records in a table
with IDs from N to N+K-1. which is equivalent to:

insert into `mytable`.`myfield` (id) values (2000),(2001),(2002),
(2003),(2004);

except instead of having to write out numbers manually, I want to
generate records automatically. Here N = 2000, K=5.

what's the easiest way to do this? (preferably in sql but if there is
another easy way, I'm open to hearing it)

#2 (**permalink**) 02-28-2008, 09:42 AM

On Apr 27, 5:24 pm, Jason S <jmsa...@gmail.com> wrote:
> I want to generate a bunch (10000-100000) of sample records in a table
> with IDs from N to N+K-1. which is equivalent to:
>
> insert into `mytable`.`myfield` (id) values (2000),(2001),(2002),
> (2003),(2004);
>
> except instead of having to write out numbers manually, I want to
> generate records automatically. Here N = 2000, K=5.
>
> what's the easiest way to do this? (preferably in sql but if there is
> another easy way, I'm open to hearing it)

I don't know if it's exactly what you're after, but back in June of
last year Giuseppe Maxia describe a method for doing this sort of
thing with dates, words and numbers all purely within mysql.

http://tinyurl.com/26xf2j

HIH

#3 (**permalink**) 02-28-2008, 09:42 AM

On Apr 28, 9:22 am, strawberry <zac.ca...@gmail.com> wrote:
> I don't know if it's exactly what you're after, but back in June of
> last year Giuseppe Maxia describe a method for doing this sort of
> thing with dates, words and numbers all purely within mysql.
>
> http://tinyurl.com/26xf2j
>
> HIH

thanks, that's the kind of thing. clever!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

generating lots of sample records