Breaking News: Grepper is joining You.com. Read the official announcement!

python mysql insert csv

Shiny Skylark answered on November 1, 2020 Popularity 9/10 Helpfulness 4/10

answer python mysql insert csv

related Insert .csv file to mysql table

python mysql insert csv

Comment

# Insert DataFrame to Table
for row in df.itertuples():
    cursor.execute('''
                INSERT INTO TestDB.dbo.people_info (Name, Country, Age)
                VALUES (?,?,?)
                ''',
                row.Name, 
                row.Country,
                row.Age
                )
conn.commit()

Popularity 9/10 Helpfulness 4/10 Language python

Source: datatofish.com

Tags: csv python

Link to this answer
Share Copy Link

Contributed on Nov 01 2020

Shiny Skylark

0 Answers Avg Quality 2/10

Closely Related Answers

Insert .csv file to mysql table

Comment

-1

LOAD DATA INFILE 'c:/tmp/discounts.csv' 
INTO TABLE discounts 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
-- USE IGNORE ROWS IF FILE HAVE UNNECESSARY DATA
-- USE LINES TERMINATED TO TELL START A NEW ROW

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: file

Link to this answer
Share Copy Link

Contributed on Jan 06 2023

Akshit Singhal

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

python mysql insert csv

Contents

More Related Answers

python mysql insert csv

Closely Related Answers

Insert .csv file to mysql table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.