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