Results 1 to 1 of 1
Sep 12, 2002, 11:35 #1
- Join Date
- Sep 2001
- Planet Namek
- 0 Post(s)
- 0 Thread(s)
import csv into mySQL and then do a fulltext search?
this might be a little tricky.
I understand on how to import csv data into mySQL, the problem arises in normalizing the data that is pulled from the csv...
in my clients CSV he has three columns: CAT, SUBCAT, GROUP
these have repitious data in them. what he wants to be able to do is export from his product program to a CSV. then go to his CMS on his website, upload the CSV and then be able to go to his website and browse by category and search through categories.
Am i going to notice a large slowdown if I don't normalize those fields.
If i do need to normalize them, how can i do this easily without too much trouble.
These 3 columns have many different categories and groups and change on a weekly basis.
thank you for any help someone can provide.