(Recent tables) ...
There are no recent tables
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.emVudGFvZXA=
cm9vdA==.emVudGFvZXA=
0
zentaoep
Javascript must be enabled past this point
Server: localhost:3306
»
Database: zentaoep
»
Table: zt_grouppriv
Browse
Structure
SQL
Search
Insert
Export
Import
Operations
Triggers
The column name 'group' is a MySQL reserved keyword.
#
Name
Type
Collation
Attributes
Null
Default
Extra
Action
1
group
mediumint(8)
UNSIGNED
No
0
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
2
module
char(30)
utf8_general_ci
No
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
3
method
char(30)
utf8_general_ci
No
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Check All
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Move the columns by dragging them up and down.
Print view
Propose table structure
Move columns
Add
column(s)
At End of Table
At Beginning of Table
After
group
module
method
Indexes
No index defined!
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Drop
group
BTREE
Yes
No
group
A
No
module
A
No
method
4571
A
No
Create an index on
columns
Information
Space usage
Data
849.9
KiB
Index
121
KiB
Overhead
28.6
KiB
Effective
942.4
KiB
Total
970.9
KiB
Optimize table
Row statistics
Format
static
Collation
utf8_general_ci
Rows
4,571
Row length
184 B
Row size
218 B
Creation
Jul 17, 2019 at 03:48 PM
Last update
Nov 23, 2022 at 05:29 PM
The column name 'group' is a MySQL reserved keyword. Print view Propose table structure
Move columns
