tiki16
04-10-2007, 02:39 PM
Hello, I am taking an existing Db (single table) and would like to import the columns and fieldsets into a new Db whereby I can map the contents of a column into multiple columns with corresponding fields. The DB was created by a CMS form creator. I had no input into the setup of th fieldsets when the Db was created. The Db was populated with question results from an online survey. The DB has all the question results in one column, name, address, email etc. Rather than having them setup as there own column headings.
When someone fills out a form an ID is associated with that survey. The table is setup with 4 columns with the headings survey ID, Question ID, Question and Answer.
Is there a way through mysql i can map the existing columns and fields into a new Db that has columns and fieldsets that are more intuitive.
The biggest problem is that I have to import it into Access and create specialised queries. at the moment the Db is not structured in a manner that allows me to sort a name, address and phone all in one query. I can only sort one fiedset at a time because all the data is contained in the one column.
Any help greatly appreciated.
I am a noob.
regards
Steve
When someone fills out a form an ID is associated with that survey. The table is setup with 4 columns with the headings survey ID, Question ID, Question and Answer.
Is there a way through mysql i can map the existing columns and fields into a new Db that has columns and fieldsets that are more intuitive.
The biggest problem is that I have to import it into Access and create specialised queries. at the moment the Db is not structured in a manner that allows me to sort a name, address and phone all in one query. I can only sort one fiedset at a time because all the data is contained in the one column.
Any help greatly appreciated.
I am a noob.
regards
Steve