/SQL/Distinct data types in a table sql query

Distinct data types in a table sql query

select table_name, count(*)
from 
	(select distinct data_type as data_type, table_name 
	 FROM information_schema.columns
	WHERE table_name like '<table-name>') t
group by table_name

Similar codes

0 vote276 views1 answer
Mariadb cast null to 0
SQL
0 vote256 views1 answer
Postgres full text search example
SQL
0 vote265 views1 answer
Fast sql column count
SQL
0 vote253 views1 answer
1 column values in to 1 single row in sql
SQL
-1 vote285 views1 answer
Utf8_encode mysql
SQL
0 vote287 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote252 views1 answer
Mysql max number not returning correct value
SQL
32 votes318 views6 answers
Rename column mysql
SQL
3 votes262 views1 answer
Select without null values sql
SQL
1 vote257 views1 answer
Mysql random limit 1
SQL