Advertisement
hanski07

Find data type of mysql column

Dec 19th, 2014
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.11 KB | None | 0 0
  1. SELECT DATA_TYPE
  2. FROM information_schema.COLUMNS
  3. WHERE TABLE_NAME = 'YOUR TABLE'
  4. AND COLUMN_NAME = 'YOUR COLUMN';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement