meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 4 months |
| seen | Mar 20 at 23:10 | |
| stats | profile views | 5 |
|
Feb 22 |
answered | syntax error within php script sql statement |
|
Feb 1 |
awarded | Supporter |
|
Feb 1 |
comment |
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields Hey, I wish I could solve your question with a query. If I can come up with something I will let you know. But for now I think that the best solution by far is to use PHP. Good luck with your project. |
|
Feb 1 |
comment |
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields @jozenovak group_concat does indeed have a limit. You can alter the limit by using SET [GLOBAL | SESSION] group_concat_max_len = type in a value;. See SO stackoverflow.com/questions/5445048/…. However at some point it will also truncate your output. You could try to create a temporal table. I have tried both action before, so I will need to read up on that to answer your question. A less complicate option will probably be to use php to split up the query. |
|
Feb 1 |
awarded | Commentator |
|
Feb 1 |
comment |
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields @jozenovak I am a bit puzzled is this what you need sqlfiddle.com/#!2/5ce07/53. If not could you explain your question by showing the results you need? |
|
Jan 29 |
revised |
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields Reformat SQL query |
|
Jan 29 |
suggested | suggested edit on Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields |
|
Jan 27 |
answered | Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields |
|
Jan 26 |
comment |
How can I best combine 3 queries into 1? @nick is you problem solved? Or do you still need help? |
|
Jan 24 |
comment |
Select multiple columns in subquery @BradleyWeston list one engine based on what? You need to define a decision rule on which basis this engine is selected. For example, if you want the first one that appears in the query? -> Use LIMIT. |
|
Jan 24 |
comment |
Select multiple columns in subquery could you show an example table with your desired output? |
|
Jan 21 |
comment |
Getting repeated value in a group_concat only if ids are different @ypercube you are correct my query doesn't show the requested 3 items. Yours answer does. |
|
Jan 21 |
comment |
Getting repeated value in a group_concat only if ids are different thank you for the credit. |
|
Jan 21 |
revised |
Getting repeated value in a group_concat only if ids are different deleted 83 characters in body |
|
Jan 21 |
comment |
Getting repeated value in a group_concat only if ids are different do you mean that you want to get the number of products with a specific activity_type. For example, Migration has 1 distinct prod_id (3). You now want to only get one category_id (12465) and not 2 (12465, 12465) like you now get? |
|
Jan 21 |
revised |
Getting repeated value in a group_concat only if ids are different added 79 characters in body |
|
Jan 21 |
answered | Getting repeated value in a group_concat only if ids are different |
|
Jan 20 |
comment |
Can't create table with this script @ypercube his transactions are no update no delete on action. With regard to the data integrity you can accomplish that without transactions. |
|
Jan 20 |
awarded | Editor |
