MySQL Information Schema is different from DESC Result

53 Views Asked by At

I've a table with a column that was created with type "date". Later the type was changed to "datetime".

desc shows column type as datetime, but if I find the column type from INFORMATION_SCHEMA.COLUMNS then the datatype is shown as "date". Here is the query


    SELECT column_name, data_type, column_type
    FROM INFORMATION_SCHEMA.COLUMNS
     WHERE table_name = '<My Table Name>'
    AND column_name = '<Column Name>'

This shows data_type and column_type as "date"

My question is why does "desc " shows different datatype than the one displayed by the query.

0

There are 0 best solutions below