Painting Blue Code
Simple, self-explanatory code snippets.
2018-08-26
Python/MySQL - How to overcome MySQL GROUP_CONCAT character limit
cursor.execute(
'
SET SESSION group_concat_max_len = 1000000;
\
SELECT a, b, c \
FROM table_name \
WHERE field_name = %s \
;'
, [
variable_for_where_clause
]
,
multi=True
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment