We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
CONCAT(NULL, ...)
For one to many relationships puts the fields from the many table into a CONCAT, i.e...
{ one_id, many: { many_id, could_be_null_field } } // Results in... // ... GROUP_CONCAT(CONCAT(many_id, could_be_null_field))...
Which if could_be_null_field is null the whole row will be excluded.
could_be_null_field
CONCAT() returns NULL if any argument is NULL.
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat
The text was updated successfully, but these errors were encountered:
2a81889
fix: ensure emptry records in GROUP_CONCAT are ignored, fix #34
2050cb6
adc7cde
No branches or pull requests
For one to many relationships puts the fields from the many table into a CONCAT, i.e...
Which if
could_be_null_field
is null the whole row will be excluded.https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat
The text was updated successfully, but these errors were encountered: