Greetings All!
I'm trying to tidy things up in my database - as when I first started I didn't really organise things all that well (as a fairly green novice!).
I originally created a range of different columns eg. one each for 'pps', 'ppl', 'ppc' etc ... Each one of these has a value of either 'Yes' or 'No'.
In hindsight, it would have been far better to have one column called 'Program Type' and filled it with multiple values (via checkboxes or similar).
Is there a way to do this - I am assuming using mySQL Monitor or similar where I can eg. where pps eq 'Yes' insert into 'Program_Type' 'pps' and then do that again for each of the other columns?
I could then delete the redundant columns - thus reducing my Admin Database page to a readable size:-))
Any ideas would be appreciated.
Regards,
Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory
I'm trying to tidy things up in my database - as when I first started I didn't really organise things all that well (as a fairly green novice!).
I originally created a range of different columns eg. one each for 'pps', 'ppl', 'ppc' etc ... Each one of these has a value of either 'Yes' or 'No'.
In hindsight, it would have been far better to have one column called 'Program Type' and filled it with multiple values (via checkboxes or similar).
Is there a way to do this - I am assuming using mySQL Monitor or similar where I can eg. where pps eq 'Yes' insert into 'Program_Type' 'pps' and then do that again for each of the other columns?
I could then delete the redundant columns - thus reducing my Admin Database page to a readable size:-))
Any ideas would be appreciated.
Regards,
Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory