Server: mysql wampserver »Database: information_schema »Table: COLUMNS
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 24 (1662 total, Query took 0.0875 sec)
SELECT * FROM `COLUMNS`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT
def information_schema CHARACTER_SETS CHARACTER_SET_NAME 1 NO varchar 32 96 NULLNULLNULLutf8 utf8_general_ci varchar(32)select
def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULLNULLNULLutf8 utf8_general_ci varchar(32)select
def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULLNULLNULLutf8 utf8_general_ci varchar(60)select
def information_schema CHARACTER_SETS MAXLEN 4 0NO bigint NULLNULL19 0 NULLNULLNULLbigint(3)select
def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULLNULLNULLutf8 utf8_general_ci varchar(32)select
def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULLNULLNULLutf8 utf8_general_ci varchar(32)select
def information_schema COLLATIONS ID 3 0NO bigint NULLNULL19 0 NULLNULLNULLbigint(11)select
def information_schema COLLATIONS IS_DEFAULT 4 NO varchar 3 9 NULLNULLNULLutf8 utf8_general_ci varchar(3)select
def information_schema COLLATIONS IS_COMPILED 5 NO varchar 3 9 NULLNULLNULLutf8 utf8_general_ci varchar(3)select
def information_schema COLLATIONS SORTLEN 6 0NO bigint NULLNULL19 0 NULLNULLNULLbigint(3)select
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1 NO varchar 32 96 NULLNULLNULLutf8 utf8_general_ci varchar(32)select
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2 NO varchar 32 96 NULLNULLNULLutf8 utf8_general_ci varchar(32)select
def information_schema COLUMNS TABLE_CATALOG 1 NO varchar 512 1536 NULLNULLNULLutf8 utf8_general_ci varchar(512)select
def information_schema COLUMNS TABLE_SCHEMA 2 NO varchar 64 192 NULLNULLNULLutf8 utf8_general_ci varchar(64)select
def information_schema COLUMNS TABLE_NAME 3 NO varchar 64 192 NULLNULLNULLutf8 utf8_general_ci varchar(64)select
def information_schema COLUMNS COLUMN_NAME 4 NO varchar 64 192 NULLNULLNULLutf8 utf8_general_ci varchar(64)select
def information_schema COLUMNS ORDINAL_POSITION 5 0NO bigint NULLNULL20 0 NULLNULLNULLbigint(21) unsignedselect
def information_schema COLUMNS COLUMN_DEFAULT 6 NULLYES longtext 4294967295 4294967295 NULLNULLNULLutf8 utf8_general_ci longtextselect
def information_schema COLUMNS IS_NULLABLE 7 NO varchar 3 9 NULLNULLNULLutf8 utf8_general_ci varchar(3)select
def information_schema COLUMNS DATA_TYPE 8 NO varchar 64 192 NULLNULLNULLutf8 utf8_general_ci varchar(64)select
def information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9 NULLYES bigint NULLNULL20 0 NULLNULLNULLbigint(21) unsignedselect
def information_schema COLUMNS CHARACTER_OCTET_LENGTH 10 NULLYES bigint NULLNULL20 0 NULLNULLNULLbigint(21) unsignedselect
def information_schema COLUMNS NUMERIC_PRECISION 11 NULLYES bigint NULLNULL20 0 NULLNULLNULLbigint(21) unsignedselect
def information_schema COLUMNS NUMERIC_SCALE 12 NULLYES bigint NULLNULL20 0 NULLNULLNULLbigint(21) unsignedselect
def information_schema COLUMNS DATETIME_PRECISION 13 NULLYES bigint NULLNULL20 0 NULLNULLNULLbigint(21) unsignedselect

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view