MySQL Show Column Data Types #tags: MySQL

query.sql

SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name = 'oxarticles' AND COLUMN_NAME = 'OXID';
  
SELECT
  COLUMN_NAME, DATA_TYPE 
FROM
  INFORMATION_SCHEMA.COLUMNS 
WHERE
  TABLE_SCHEMA = 'ods'
AND
  TABLE_NAME = 'oxarticles';
  
SHOW FIELDS FROM oxarticles
  
EXPLAIN ods.oxarticles;
DESCRIBE ods.oxarticles;
SHOW FIELDS FROM ods.oxarticles;
SHOW COLUMNS FROM ods.oxarticles;