FastNetMon

Wednesday 11 April 2012

Как посмотреть максимальный размер поля в MySQL?

Вот такой хитрой командой:
SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'table_name' AND table_schema = 'db_name' and column_name = 'column_name';

Источник: http://stackoverflow.com/questions/4990385/determine-max-length-allowed-in-a-column-in-mysql

No comments :

Post a Comment

Note: only a member of this blog may post a comment.