Loop ?

[snappy]

Hi all,

I would like to create the following

Col 1	Col2
1	1
2	1
3	1
4	1
5	1
1	2
2	2
3	2
4	2
5	2
1	3
2	3
3	3
4	3
5	3

in a mysql table with much larger numbers.

I have experimented with loops but I can not seem to get anything right

[laserlight]

That's rather trivial:

for i = 1 to i = n
	for j = 1 to j = 5
		print j, i

Now, why would you want to do this, and why store in a database?

[snappy]

Thank you very much