Timeline for to_sql pyodbc count field incorrect or syntax error
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 28, 2024 at 21:42 | comment | added | Alex Sham | 2024 - still working | |
| Jan 5, 2021 at 16:57 | history | edited | Gord Thompson | CC BY-SA 4.0 |
added 1588 characters in body
|
| Jun 5, 2020 at 11:48 | comment | added | Gord Thompson | @Nikhil - I would presume so, yes. | |
| Jun 5, 2020 at 11:27 | comment | added | Nikhil VJ | does this 2100 limit also apply to delete statements? | |
| Jun 5, 2020 at 10:42 | comment | added | Nikhil VJ |
I'm finding the .to_sql performance better with method='multi', chunksize=tsql_chunksize as recommended here. Thanks for this!
|
|
| Jul 13, 2019 at 14:11 | comment | added | Ilja Everilä |
I think they changed it one more time and added a method argument that defaults to None, or in other words the old row-by-row/executemany behaviour. If passed "multi", it'll use the multiple-values insert. It also enables more complex handling, if passed a callable — allows using for example Postgresql's COPY.
|
|
| Aug 23, 2018 at 19:11 | history | edited | Gord Thompson | CC BY-SA 4.0 |
added 127 characters in body
|
| Jun 14, 2018 at 0:07 | history | edited | Gord Thompson | CC BY-SA 4.0 |
added 220 characters in body
|
| Jun 11, 2018 at 23:31 | history | edited | Gord Thompson | CC BY-SA 4.0 |
elaborate
|
| Jun 11, 2018 at 17:07 | comment | added | Gord Thompson |
@user3725021 - I agree that the pandas update should have taken the T-SQL limits into account, at least for the SQL Server dialect. We can work around those with the chunksize argument of to_sql, but it would be better if pandas took care of that itself.
|
|
| Jun 11, 2018 at 8:15 | comment | added | user3725021 | Seems like an odd update? I imagine the a significant percentage of users will want to insert dataframes containing > 2100 params... SQL Server built for large datasets... | |
| Jun 6, 2018 at 1:12 | history | edited | Gord Thompson | CC BY-SA 4.0 |
added 19 characters in body
|
| Jun 5, 2018 at 18:25 | vote | accept | Ryan | ||
| Jun 5, 2018 at 18:20 | history | edited | Gord Thompson | CC BY-SA 4.0 |
added 13 characters in body
|
| Jun 5, 2018 at 17:55 | history | answered | Gord Thompson | CC BY-SA 4.0 |