Author | Message |
---|---|
BrianK
Posts: 25
|
Posted 21:58 Apr 08, 2017 |
Here's a way to import CSV to MySQL for those that need it: 1. Use FileZilla/FTP to transfer the 'Salaries.csv' to the www folder on CS3. 2. SSH into CS3 (PuTTY) 3. Type 'mysql -p' 4. Login using your pw 5. Type 'use cs3220stuXX' 6. Copy, Right Click to Paste (Might want to drop any pre-existing "Salaries" table using PHPmyAdmin) LOAD DATA LOCAL INFILE 'www/Salaries.csv' 7. Profit And it should take about 10 secs to import. Much better than the MySQL Workbench solution. Last edited by BrianK at
21:58 Apr 08, 2017.
|