Skip to content

Instantly share code, notes, and snippets.

@ppazos

ppazos/colums_with_type.sql

Created October 19, 2025 01:53
Show Gist options
  • Save ppazos/2bfc1be109f0097dad212b3a0678e3bc to your computer and use it in GitHub Desktop.
Save ppazos/2bfc1be109f0097dad212b3a0678e3bc to your computer and use it in GitHub Desktop.
Download ZIP
Get columns with a specific type from mysql
Raw
colums_with_type.sql
SELECT
TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
DATA_TYPE = 'datetime' AND TABLE_SCHEMA = 'atomik'
ORDER BY
TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment