Server: mysql wampserver »Database: mysql »Table: user"Users and global privileges"
#NameTypeCollationAttributesNullDefaultExtraAction
1char(60)utf8_bin No Change ChangeDrop Drop
2char(16)utf8_bin No Change ChangeDrop Drop
3char(41)latin1_bin No Change ChangeDrop Drop
4enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
5enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
6enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
7enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
8enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
9enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
10enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
11enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
12enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
13enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
14enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
15enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
16enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
17enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
18enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
19enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
20enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
21enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
22enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
23enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
24enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
25enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
26enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
27enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
28enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
29enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
30enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
31enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
32enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
33enum('', 'ANY', 'X509', 'SPECIFIED')utf8_general_ci No Change ChangeDrop Drop
34blob No NoneChange ChangeDrop Drop
35blob No NoneChange ChangeDrop Drop
36blob No NoneChange ChangeDrop Drop
37int(11)UNSIGNEDNo 0Change ChangeDrop Drop
38int(11)UNSIGNEDNo 0Change ChangeDrop Drop
39int(11)UNSIGNEDNo 0Change ChangeDrop Drop
40int(11)UNSIGNEDNo 0Change ChangeDrop Drop
41char(64)utf8_bin Yes Change ChangeDrop Drop
42textutf8_bin Yes NULLChange ChangeDrop Drop
43enum('N', 'Y')utf8_general_ci No NChange ChangeDrop Drop
With selected:With selected:

Print view Print viewPropose table structure Propose table structureDocumentation Move columns Move columns
Add columnAdd column(s)
Information
Space usage
Data212B
Index2KiB
Total2.2KiB
Row statistics
Formatdynamic
Collationutf8_bin
Rows4
Row length53 B
Row size565 B
CreationMar 14, 2014 at 01:30 PM
Last updateMay 01, 2014 at 09:06 AM