help with mysql query

[Daffy_Duck]

Hi I want to grab 1m rows from a db starting from row 5m to row 6m

I did this..

INSERT INTO table1 (domain) SELECT domain FROM table2 LIMIT 5000000, 6000000;

But it inserted 6m rows

Whats wrong with the above?

Thanks

[Sxooter]

Daffy Duck wrote:

Hi I want to grab 1m rows from a db starting from row 5m to row 6m

I did this..

INSERT INTO table1 (domain) SELECT domain FROM table2 LIMIT 5000000, 6000000;

But it inserted 6m rows

Whats wrong with the above?

It did exactly what you told it to.

The args to limit are offset, limit. So you told it to give you 6m rows offset by 5m.

If you use the limit/offset syntax it's more obvious:

INSERT INTO table1 (domain) SELECT domain FROM table2 LIMIT 1000000, offset 5000000 -- not sure if the , is normal in mysql

Notice that it's much more readable and understandable.

[Daffy_Duck]

ah thanks that makes scense so I guess I need to do

INSERT INTO table1 (domain) SELECT domain FROM table2 LIMIT 5000000, 1000000;

[Sxooter]

Yours and mine are functionally equivalent. Mines a bit easier to read for someone not familiar with MySQL, and is transportable to postgresql.

Other that, no diff really...

[Daffy_Duck]

thanks