MySQL Tables

[Frenzy]

Hi,

Is there any way to make a php script that, when a mysql table reach for example : 3000 entries, it creates another named like table_2 and same thing when this table reaches max hits...


Thanks,
Max

[atlas]

Yes, but it would have to be function of your script to check this condition and then create a new table.

Why would you want to do this though?

-mk

[Niaad]

You could just give an ID to each entry in the table (which you probably do anyway), and as long as no entries are missing, you could just check to see if there is an ID of 3000...if there is, create a new table instead.

Just a suggestion :)

[atlas]

select count(*) from tableName;


Much better solution -- but I don't think that's the issue here.

-mk
atlascgi.com