How to store text file into MySQL database using python

Question

import MySQLdb
import re

def write():
    file = open('/home/fixstream/Desktop/test10.txt', 'r')
    print file.read()
    file.close()
write()

Above code i have, now i want to store the text file into mysql db. I am new to python as well as database. So anyone can help me with this?

You've written barely enough code to open the file. But there's is no code to parse it, or to connect to the database. Look up a few examples and come back with an example of an objective problem you are having. — user764357
– user764357, Commented Aug 12, 2014 at 20:57

Community · Accepted Answer · 2017-05-23 11:33:13Z

11

I suggest you reading this MySQLdb tutorial. First, you need to store content of the file in a variable. Then it's simply connecting to your database (which is done as you can see in the link) and then executing INSERT query. Prepared statements are done in similar way as common string formatting in python.

You need something like this:

import MySQLdb

db = MySQLdb.connect("localhost","user","password","database")
cursor = db.cursor()

file = open('/home/fixstream/Desktop/test10.txt', 'r')
file_content = file.read()
file.close()

query = "INSERT INTO table VALUES (%s)"

cursor.execute(query, (file_content,))

db.commit()
db.close()

Note the comma after file_content - this ensures the second argument for execute() is a tuple. Also note db.commit() which ensures writing changes.

If you need further explanation, ask.

edited May 23, 2017 at 11:33

CommunityBot

11 silver badge

answered Aug 12, 2014 at 21:17

kecer

3,1312 gold badges23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to store text file into MySQL database using python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related