Hi, I want to copy some data from one table (say from db1) to 50 different tables depend on state name of first table (db1). Can I do it in one sql statement? I mean reading the “state” column from db1 and then inserting into different table depending on the state name. ? If its possible could you please give a hint. If not, then what is the best way to do it? Thank you.

cannot see why you would want to create redundant data in many tables this way, but it could be done depending on the database server and if it supported stored procedures.

Well, its not really redundant data, because different tables store the data for different states. Well, I know it can be done using one table and initially I was surprised why 50 different table was created but then I was told, it help reduce search time. By the way, it’s a shared server and I only have access to myphpadmin. So, Can I do this?

By the way, i am using mysql 4.0.16, so it doesn't support stored procedures.