Tuesday, December 4, 2012

show column definition


mysql> SELECT column_name, data_type, character_maximum_length, column_comment FROM information_schema.columns WHERE table_name = 'TABLE_NAME';

mysql> SHOW FULL COLUMNS FROM tableName;

No comments: