get the datatype and the columns of the table code example
Example: get the datatype and the columns of the table
mysql> select data_type from information_schema.columns where table_schema = 'business' and able_name = 'DataTypeDemo';
mysql> select data_type from information_schema.columns where table_schema = 'business' and able_name = 'DataTypeDemo';