reset password
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'
INTO TABLE Salaries
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

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.