Upload csv file using mysql within popSQL

148 views Asked by At

I used the command line to load my csv file. I want to know how to import/upload it within popsql so I can write queries. The database is connected.

Command line code
mysql> LOAD DATA LOCAL INFILE '/Users/anishachoudhury/Desktop/Anisha/mysql/school-closures-covid.csv' 
    -> INTO TABLE faceCoverings
    -> IGNORE 1 ROWS;
Query OK
0

There are 0 answers