projects:digikey_partsdb
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| projects:digikey_partsdb [2013/10/13 10:10] – charliex | projects:digikey_partsdb [2013/10/13 10:11] (current) – charliex | ||
|---|---|---|---|
| Line 1004: | Line 1004: | ||
| I used one of the online CSV to MYSQL converters, but most of them can't handle the variations in CSV. To create the initial schema for each table i converted one CSV to XLS by importing it into google docs, and then re-exporting it as an XLS then importing that into phpmyadmin, that makes the base schema.< | I used one of the online CSV to MYSQL converters, but most of them can't handle the variations in CSV. To create the initial schema for each table i converted one CSV to XLS by importing it into google docs, and then re-exporting it as an XLS then importing that into phpmyadmin, that makes the base schema.< | ||
| - | Rename the table in phpmyadmin<br> | + | Rename the table in phpmyadmin |
| - | <br> | + | |
| - | then do the final import with the csvtosql<br> | + | Then do the final import with the csvtosql |
| + | |||
projects/digikey_partsdb.1381684240.txt.gz · Last modified: by charliex