(Recent tables) ...
`mysql`.`general_log`
`mysql`.`user`
New
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.bm9tYnJlcyBwZXJzb25hbGVz
cm9vdA==.bm9tYnJlcyBwZXJzb25hbGVz
0
nombres personales
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cmVhZG1lX3RvX3JlY292ZXJfc3o=
cm9vdA==.cmVhZG1lX3RvX3JlY292ZXJfc3o=
0
readme_to_recover_sz
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
cm9vdA==.dGVzdDI=
cm9vdA==.dGVzdDI=
0
test2
cm9vdA==.dGVzdDM=
cm9vdA==.dGVzdDM=
0
test3
Javascript must be enabled past this point
Server: mysql wampserver
»
Database: information_schema
»
Table: COLUMNS
Browse
Structure
SQL
Search
Export
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.0707 sec)
SELECT * FROM `COLUMNS`
Profiling
[
Inline
] [
Edit
] [
Explain SQL
] [
Create PHP Code
] [
Refresh
]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
|
|
Number of rows:
25
50
100
250
500
Partial texts
Full texts
Show binary contents
Show BLOB contents
Show binary contents as HEX
Hide browser transformation
Geometry
Well Known Text
Well Known Binary
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
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
def
information_schema
CHARACTER_SETS
DEFAULT_COLLATE_NAME
2
NO
varchar
32
96
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
def
information_schema
CHARACTER_SETS
DESCRIPTION
3
NO
varchar
60
180
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(60)
select
def
information_schema
CHARACTER_SETS
MAXLEN
4
0
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(3)
select
def
information_schema
COLLATIONS
COLLATION_NAME
1
NO
varchar
32
96
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
def
information_schema
COLLATIONS
CHARACTER_SET_NAME
2
NO
varchar
32
96
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
def
information_schema
COLLATIONS
ID
3
0
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(11)
select
def
information_schema
COLLATIONS
IS_DEFAULT
4
NO
varchar
3
9
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
def
information_schema
COLLATIONS
IS_COMPILED
5
NO
varchar
3
9
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
def
information_schema
COLLATIONS
SORTLEN
6
0
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(3)
select
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
COLLATION_NAME
1
NO
varchar
32
96
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
CHARACTER_SET_NAME
2
NO
varchar
32
96
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
def
information_schema
COLUMNS
TABLE_CATALOG
1
NO
varchar
512
1536
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(512)
select
def
information_schema
COLUMNS
TABLE_SCHEMA
2
NO
varchar
64
192
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
def
information_schema
COLUMNS
TABLE_NAME
3
NO
varchar
64
192
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
def
information_schema
COLUMNS
COLUMN_NAME
4
NO
varchar
64
192
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
def
information_schema
COLUMNS
ORDINAL_POSITION
5
0
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
def
information_schema
COLUMNS
COLUMN_DEFAULT
6
NULL
YES
longtext
4294967295
4294967295
NULL
NULL
NULL
utf8
utf8_general_ci
longtext
select
def
information_schema
COLUMNS
IS_NULLABLE
7
NO
varchar
3
9
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
def
information_schema
COLUMNS
DATA_TYPE
8
NO
varchar
64
192
NULL
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
def
information_schema
COLUMNS
CHARACTER_MAXIMUM_LENGTH
9
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
def
information_schema
COLUMNS
CHARACTER_OCTET_LENGTH
10
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
def
information_schema
COLUMNS
NUMERIC_PRECISION
11
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
def
information_schema
COLUMNS
NUMERIC_SCALE
12
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
def
information_schema
COLUMNS
DATETIME_PRECISION
13
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
|
|
Number of rows:
25
50
100
250
500
Query results operations
Print view
Print view (with full texts)
Export
Display chart
Create view