title: Read from csv file and put to Mysql with different field type using python
body: <p>i have table field of "datetime", "integer", "double", "string (varchar)" type in Mysql, how can i convert from string (from csv file) to each type of Mysql field using python ? example of my csv file :</p>
  
  <p>EURUSD;M5;2011.01.05 02:10:00;1.33193;1.33193;1.33112;1.33135;0;-1;0;0;1.33215</p>
  
  <p>My python code is like this :</p>
  
  <pre><code>import MySQLdb
  
  # Open database connection 
  db = MySQLdb.connect("localhost","me","xxxxx","test" )
  
  # prepare a cursor object using cursor() method 
  cursor = db.cursor()
  
  inputFile = "source.csv"
  
  with open(inputFile, 'r') as fr:
      data = fr.readlines()
  
      for line in data:
          words = line.strip().split(";")
  
          getpair = words[0]
          gettf = words[1]
          gettime = (datetime) words[2]
          getopen = (double) words[3]
          gethigh = (double) words[4]
          getlow  = (double) words[5]
          getclose = (double) words[6]
          getcUpdown = (int) words[7]
          getfractal = (int) words[8]
          getzzId = (int) words[9]
          getzzUpdown = (int) words[10]
          getzzEndPrc = (double) words[11]
  
          print(getpair,"=",gettf,"=",gettime,"=",getopen,"=",gethigh,"=",getlow,"=",getclose,"=",getcUpdown,"=",getfractal,"=",getzzId,"=",getzzUpdown,"=",getzzEndPrc)
  
      #  =====================================================================
      # Prepare SQL query to INSERT a record into the database.
      sql = '''INSERT INTO `mytable` (pair,timeframe,time,open,close,high,low,updown,fractal,zzid,zzupdown,zzlength) \
           VALUES (getpair,gettf,gettime,getopen,getclose,gethigh,getlow,getcUpdown,getfractal,getzzId,getzzUpdown,getzzEndPrc)'''
  
      try:
         # Execute the SQL command
         cursor.execute(sql)
         # Commit your changes in the database
         db.commit()
      except:
         # Rollback in case there is any error
         db.rollback()
  
      # disconnect from server
      db.close()
  
  fr.close()
  </code></pre>
  
  <p>Thanks
  p</p>