Transact SQL – STRING_AGG

Background In our post on MySQL - Information_schema.statistics we spoke glowingly of the GROUP_CONCAT Function. I really could not find a way around using it in MySQL. I ran into some difficulties using it and as with problems one just googles for workarounds. BTW, the MySQL post is here. SQL Server Introduction It seems that … Continue reading Transact SQL – STRING_AGG

MySQL – information_schema.statistics

Background As a quick follow-up to our discussion of metadata on tables, let us discuss indexes. BTW, the discussion on tables is here. INFORMATION_SCHEMA.STATISTICS Code Output   Comparison with Other Databases GROUP_CONCAT The group_concat is very, very powerful and has few equal in other database platforms Function Documentation   SHOW INDEX To get a bit … Continue reading MySQL – information_schema.statistics