Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def stop(l,owner):
- cursor=MySQLdb.connect("localhost","root","password","exp").cursor()
- query="CREATE TABLE data (tweet varchar(140),owner varchar(50))"
- cursor.execute(query)
- c=0
- for i in l:
- currentUser=owner[c]
- c=c+1
- for j in i:
- text=MySQLdb.escape_string(j.text)
- cursor.execute("""INSERT INTO data VALUES("%s","%s")"""%(text,currentUser))
- print "done"
Advertisement
Add Comment
Please, Sign In to add comment