data transfer from pandas to mysql server by mysql connector python

  Kiến thức lập trình

i am planning to insert my pandas data into mysql server with the help of mysql connect python libracy in VS code, but howerer i am unable to do it eventhough my code didn’t any error and also the data isn’t inserting into my mysql server, i have shared my code below.

I have tried to use pandas method of pd.to_sql to mysql server, but failed, i wanted to know whether is there any changes to be done in my code in order to insert my pandas data in this case, it’s the values data in my code to be inserted into channel_table(Youtube_database) in mysql server

New contributor

Prakash R is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.