So, In SQL, We have the following query to find the system data type ID of columns in SQL Server;
select name, system_type_id from sys.columns where object_id = OBJECT_ID(N'sometable')
It gives the following output;
name system_type_id rowid 56 Client 167 IsCurrent 104
The system_type_id represents the int value of data type of that column.
Whereas, when I tried to convert (find an equivalent) in MySQL, I couldn't find the ID of column's data type. The following is the query I have managed to find so far;
SELECT column_name,data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'someSchema' AND TABLE_NAME = 'someTable';
It gives the following output.
# column_name, data_type 'rowid', 'int' 'Client', 'varchar' 'IsCurrent', 'tinyint'
Any suggestions how I can achieve the earlier output in MySQL ?