MySQL table

[indiaoz]

Hi

I've got a MYSQL table which only has one field. At the moment they are around 2000 rows. I want create more tables and break up the existing table so that there are only 300 rows in each table.

What MySql command do I need to do this. I was thinking something along the lines of putting in id and then executing some query.

What would this query be.

Thanks,
Ajay

[seanf]

I have removed your other thread asking this question. If a thread is in the wrong forum you can contact an Advisor and ask for it to be moved instead of creating a new thread

Sean

[r937]

the command for creating more tables is CREATE TABLE

i'm just curious, what's in that column and why do you feel you need more tables?

[indiaoz]

I know how to create a table but I need to basically copy a table but only copy the first 300 records into the table.

How do I do this.

Thanks

[r937]

the first 300 based on what column?

insert into table2 (foo, bar)
select qux, baz
from table1
order by somecolumn
limit 300

[indiaoz]

Thanks that works. Now how do I get the next 300 then the next 300 etc.

Thanks A lot,
Ajay

[redemption]

Like rudy asked, I'm also curious why you have a table like this, and why you needed to split it up. Clue us in?

Getting records 301-600:
insert into table2 (foo, bar)
select qux, baz
from table1
order by somecolumn
limit 300, 300

Getting records 301-600:
insert into table2 (foo, bar)
select qux, baz
from table1
order by somecolumn
limit 600, 300

You get the idea.