How to fetch data from MySQL table using python pandas.

preview_player
Показать описание
Pandas python program to fetch data from MySQL table.
Рекомендации по теме
Комментарии
Автор

Lets say a pandas df have column A, B, C and same is written to a mysql database

now how to upsert a pandas df to mysql table?
lets say we have a new similar df, now
If column A matches update the row in Mysql ie Column B, and C
If column a it not found, then do an Insert into

whats the most efficient way to do this?

tirtha