Store tweets from a Twitter timeline into a MySQL database using Tweepy

TWTR-mysql.py

import tweepy
import MySQLdb
import sys

# Tweepy API doc here: http://pythonhosted.org/tweepy/html/api.html

# Keys
consumer_key = ''
consumer_secret = ''
access_token = ''
access_token_secret = ''

# Twitter initialization
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)

# MySQL initialization
connection =  MySQLdb.connect(host= "localhost",
    user="?",
    passwd="?",
    db="?")
cursor = connection.cursor()

# The table schema: CREATE TABLE tweets (id INT PRIMARY KEY AUTO_INCREMENT, tweet_id BIGINT NOT NULL, tweet_text VARCHAR(160) NOT NULL, screen_name VARCHAR(160) NOT NULL, author_id INT, created_at DATETIME NOT NULL, inserted_at DATETIME NOT NULL)

try:
    statuses = api.list_timeline(api.me().screen_name, '<NAME OF TIMELINE?>')
    for s in statuses:
        # To remove duplicate entries
        cursor.execute("SELECT id FROM tweets WHERE tweet_text = %s;", [s.text])
        if cursor.rowcount == 0:
            cursor.execute("INSERT INTO tweets (tweet_id, tweet_text, screen_name, author_id, created_at, inserted_at) VALUES (%s, %s, %s, %s, %s, NOW());", (s.id, s.text, s.author.screen_name, s.author.id, s.created_at))
            connection.commit()
except tweepy.error.TweepError:
    print "Whoops, could not fetch news!"
except UnicodeEncodeError:
    pass
except:
    print "Unexpected error: ", sys.exc_info()[0]
    raise
finally:
    cursor.close()
    connection.close()

hi, this code is useful, how can i use this to get followers of an account and store their screen names in data base

Getting this error while running it
cursor.execute("INSERT INTO tweets (tweet_id, tweet_text, screen_name, author_id, created_at, inserted_at) VALUES (%s, %s, %s, %s, %s, NOW());", (s.id, s.text, s.author.screen_name, s.author.id, s.created_at))
UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2026' in position 139: ordinal not in range(256)