MySQL Forums
Forum List  »  Newbie

Re: Inserting a MySQL select result not working? part 2
Posted by: Peter Brawley
Date: October 25, 2017 02:33PM

> | YLW | 2010 | 64788,64788,64788 | 3 | 3116.6667 |

Joining on year diff between 0 and 5 will include dupes. To exclude them, you need year diff between 1 and 5.

> Warning | 1260 | Row [some row no] was cut by GROUP_CONCAT()" |

Default group_concat_max_len is 1024, try setting it to something like 20480.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.