Getting Started with various Tools

19 / 44

Importing CSV dataset in MySQL

How to import a csv file in MySQL:

  1. Using scp or other methods upload your CSV file to the CloudxLab web console in your home directory
  2. Login to MySQL shell as given in the previous slide
  3. USE sqoopex database
  4. Create the required table using CREATE TABLE command
  5. Import your CSV using the following command

    LOAD DATA LOCAL INFILE '~/file.csv' INTO TABLE my_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
    

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...