How to get missing values in row order comma separated?

Asked Nov 26 '18 at 09:24

Active Nov 26 '18 at 09:26

Viewed 131 times

I am facing issue in finding missing auto incremental ids. I am finding missing ids. from the table. Looking for msyql query.

i want result should be like this:

Thanks for the help.

edited Nov 26 '18 at 09:26

asked Nov 26 '18 at 09:24

Bhargav Dave

And what help is needed. Any code we might see in this matter? – Gauravsa Nov 26 '18 at 09:25
1

You can generate a numbers table (check here: https://stackoverflow.com/a/8349837/2469308) ; LEFT JOIN from this numbers table to your current table and get the gaps where right side table row `is null` – Madhur Bhaiya Nov 26 '18 at 09:30
Could you pelase show me any example? – Bhargav Dave Nov 26 '18 at 09:46
Possible duplicate of [MySQL get missing IDs from table](https://stackoverflow.com/questions/12325132/mysql-get-missing-ids-from-table) – Nick Nov 26 '18 at 10:21
Sorry to say, I have checked already this then after i was posting this question. There is no option for comma sperated ids. – Bhargav Dave Nov 26 '18 at 12:54
Use GROUP_CONCAT for comma separated IDs. – Ankit Bajpai Nov 26 '18 at 14:10

0 Answers0