database = mysql.connector.connect(user=settings.db_login, password=settings.db_password,
                                               host=settings.dp_ip, database=settings.db_name, use_unicode=True,
                                               charset='utf8', collation='utf8_general_ci')
cursor = database.cursor()
cursor.execute("""INSERT INTO youtube_videos (channel_ID, channel_name, channel_description, channel_startDate,
               channel_daysFromFoundation, channel_avatarImg, channel_region, channel_viewCount,
               channel_subscribersCount, channel_videoCount) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)""",
               (channel_id, channel_title, channel_description, channel_startDate, channel_daysFromFoundation, channel_avatarImg,
                channel_region, channel_viewCount, channel_subscribersCount, channel_videoCount))

Traceback (most recent call last):
  File "D:/perforce/Social/test.py", line 87, in <module>
    channel_region, channel_viewCount, channel_subscribersCount, channel_videoCount))
  File "D:Minicanoda3libsite-packagesmysqlconnectorcursor.py", line 515, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "D:Minicanoda3libsite-packagesmysqlconnectorconnection.py", line 488, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "D:Minicanoda3libsite-packagesmysqlconnectorconnection.py", line 395, in _handle_result
    raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(channel_ID, channel_name, channel_description, channel_startDate,
             ' at line 1

database = mysql.connector.connect(user=settings.db_login, password=settings.db_password,
                                               host=settings.dp_ip, database=settings.db_name, use_unicode=True,
                                               charset='utf8', collation='utf8_general_ci')
cursor = database.cursor()
cursor.execute("""SELECT ID, channel_link FROM youtube_videos""")
ID = cursor.fetchall()[0]
cursor.execute("""UPDATE youtube_videos SET channel_ID = 'channel_id' WHERE ID FROM youtube_videos = %s""", ID)