table rename caused sql problems?

[Anon]

Hi,

I got some weird problem.

In mysql database, I recreated same structure table( same column name, sam order, same column type, just size little bit different ) because one of column was not good in original table. Then I rename old table as table2, gave the new table as table1, then I dont need to change my sql statement. However, I couldn't reach data from the new table, but I could get data from table2 still if I rename table2 as table1.

Have any ideas for that?

[Anon]

Are you trying to get to the data that you stored in the original table using the new table? If so it doesn't work that way, just because you name the new table the same as the old table doesn't mean it's going to magically get all of the data that was stored in the first table. You will need to insert all of the data that you want the new table to hold.

[Anon]

Hi,

Ok, I didnt describe clearly. The new table already has all data in each column and row. It should have same data like original table, but contain better data in one column than old table.

I dont know why?

[Anon]

Maybe you should post the descriptions of both tables, and the code that you are using that doesn't work.