Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Importing a csv into mysql via command line

    @shashank.garg
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 140
    Comment on it

    Hello Readers!

    MySQL have this load data function, where we can insert data to a table from external files like csv, txt etc.

    The process is quite simple, 1st lets login to mysql via terminal/console.

    1. mysql -u root -p

    Enters username and password of mysql

    1. mysql>

    Now lets run the command.

    1. mysql> LOAD DATA LOCAL INFILE /var/www/site/site_users.csv
    2. INTO TABLE site_users FIELDS
    3. TERMINATED BY ;
    4. ENCLOSED BY 
    5. LINES TERMINATED BY \n
    6. IGNORE 1 LINES;

    You will see this if command ran successfully:

    1. Query OK, 370 rows affected (0.00 sec)
    2. Records: 370  Deleted: 0  Skipped: 0  Warnings: 0
    console csvupload php
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: