title: mysql_exceptions.OperationalError: (1054, "Unknown column 'xxx' in 'field list'")
body: <p>Here is my python code:</p>
  
  <pre><code>import MySQLdb
  
  db = MySQLdb.connect("127.0.0.1", "root", "liao", "adminset")
  cursor = db.cursor()
  
  for i in "liaogx":
      sql = """INSERT INTO cmdb_hostgroup(name, created_at, updated_at) VALUES (%s, "2018-01-31 07:50:26.879000", "2018-01-31 07:50:26.879000");""" % (i, )
      cursor.execute(sql)
  
  db.close()
  </code></pre>
  
  <p>and when I run it, the error infomation is:Traceback (most recent call last):</p>
  
  <pre><code>File "/root/Projects/adminset-master/cmdb/test.py", line 124, in &lt;module&gt;
      cursor.execute(sql)
    File "/root/.virtualenvs/adminset/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
      self.errorhandler(self, exc, value)
    File "/root/.virtualenvs/adminset/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
      raise errorvalue
  _mysql_exceptions.OperationalError: (1054, "Unknown column 'l' in 'field list'")
  </code></pre>
  
  <p>MySQL version is 5.6.38. I don't get the right answer from google, please help. thanks.</p>