Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ENH: Give DataFrame.to_sql() the option to create temporary tables. #41335

Open
salimfadhleyhtp opened this issue May 5, 2021 · 4 comments
Open

ENH: Give DataFrame.to_sql() the option to create temporary tables. #41335

salimfadhleyhtp opened this issue May 5, 2021 · 4 comments
Assignees
@TAJD
Labels
Enhancement IO SQL to_sql, read_sql, read_sql_query

Comments

@salimfadhleyhtp
Copy link

Is your feature request related to a problem?

I wish I could create temporary tables using the DataFrame.to_sql() method.

Describe the solution you'd like

Add a new boolean kwarg to the to_sql() method that if set to True, will cause the table to be created as a temporary table.

API breaking implications

One new argument, defaulting to False - shouldn't change any normalbehavior.
@salimfadhleyhtp salimfadhleyhtp added Enhancement Needs Triage Issue that has not been reviewed by a pandas team member labels May 5, 2021
@lithomas1 lithomas1 added IO SQL to_sql, read_sql, read_sql_query and removed Needs Triage Issue that has not been reviewed by a pandas team member labels May 19, 2021
@lithomas1 lithomas1 added this to the Contributions Welcome milestone May 19, 2021
@TAJD
Copy link
Contributor

TAJD commented Jul 1, 2021

take

@mroeschke mroeschke removed this from the Contributions Welcome milestone Oct 13, 2022
@redreamality redreamality mentioned this issue Oct 22, 2022
Closed
3 tasks
@pesekon2
Copy link

+1 who would appreciate this option.

@david-ashirov-mfp
Copy link

+1

@RichardZhu2
Copy link

+1

Is this being worked on?

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

@TAJD TAJD

Labels
Enhancement IO SQL to_sql, read_sql, read_sql_query
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
7 participants
@mroeschke @TAJD @pesekon2 @lithomas1 @RichardZhu2 @salimfadhleyhtp @david-ashirov-mfp