COLUMNS table provides
information about columns in tables.
CHARACTER_OCTET_LENGTH should be the same
CHARACTER_MAXIMUM_LENGTH, except for
multibyte character sets.
CHARACTER_SET_NAME can be derived from
Collation. For example, if you say
SHOW FULL COLUMNS FROM t, and you see in
Collation column a value of
latin1_swedish_ci, the character set is
what is before the first underscore:
DATETIME_PRECISION was added in MySQL
The following statements are nearly equivalent:
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '
tbl_name' [AND table_schema = '
db_name'] [AND column_name LIKE '
wild'] SHOW COLUMNS FROM
db_name] [LIKE '
Copyright © 1997, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices