Skip to content

Instantly share code, notes, and snippets.

@amirziai

amirziai/PandasMySQLSSH.ipynb

Last active October 13, 2021 04:08
Show Gist options
  • Star 14 You must be signed in to star a gist
  • Fork 5 You must be signed in to fork a gist
  • Save amirziai/9cc792e41d3241a17a18 to your computer and use it in GitHub Desktop.
Save amirziai/9cc792e41d3241a17a18 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
PandasMySQLSSH.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@AolingHmlet
Copy link

Hi May I know how to write the dataframe into the database through sshtunnel? It seems that I am only able to read but not write. Would you have any clues? Thanks a lot.

@AntonLohner
Copy link

Hi May I know how to write the dataframe into the database through sshtunnel? It seems that I am only able to read but not write. Would you have any clues? Thanks a lot.

You should be able to use the same method, replacing SELECT with INSERT or UPDATE sql statements to write the information back in, what isn't working?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment