2. PHPRunner General questions
  3. Confused about Add View
This topic is locked

Confused about Add View

 		9/28/2010 8:48:29 PM
PHPRunner General questions
K
 karmacomposer author

In the project I am working on, I need at least three tables that are all very similar, but do have some differences in the fields.
Do I Add Views or create new tables? If I have to create new tables, is there a way to copy one table's fields to another table?
Lastly, I noticed that if you make changes to a table after the database is active and has records, it will initialize the database and you will lose all records.
If that's the case, I will probably need to add fields later on. Is there any way to backup the existing data, make the changes and then import the data to the

changed database (in the correct fields)?
Thanks for your answers.
Mike
P
 		procheck 9/28/2010

Hi Mike,
Have you gone through the Normalization process for your tables? There is a lot of information about this on the net.
A great tool for managing your tables is SQLyog. I use it alongside PHPRunner. I think that you are correct that certain changes might initialize the database but I can't think of any off hand. Using SQLyog, I just added a column then deleted it and I did not lose any data. Changing an indexed field might cause some problems. This forum is not for SQLyog so if you have any questions about it you can contact me separately and I'd be happy to do any tests for you.
Al
Sergey Kornilov admin 9/29/2010

Al is correct, PHPRunner is not a database design tool though it comes with some basic database management functionality.
Good MySQL database management tools are phpMyAdmin, Navicat and SQLYog.