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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
SHOW TABLES;
Tables_in_test
A
SELECT * FROM A;
col_bigint col_enum col_char_10 col_char_1024 col_int col_char_10_not_null col_int_not_null_key col_enum_not_null col_char_1024_not_null_key col_int_key col_char_10_key col_char_1024_not_null col_enum_not_null_key pk col_bigint_key col_int_not_null col_bigint_not_null col_bigint_not_null_key col_char_10_not_null_key col_enum_key col_char_1024_key
NULL p him out NULL SATEF 4 k j NULL CSZXW JJVVK m 1 -8422575728112959488 4 8 2 e w ok
2 y he's q 3 we 7 v HLHTR NULL what ZQRDC n 2 5 1 6 8 TYZGK b JRKMQ
NULL n TOERV at 489684992 a 0 q he's -656408576 XDOYG q n 3 NULL 4 4 6 t m WCFTE
5 y see what NULL had -1408040960 p go 8 OZXNB CJZXI c 4 1 4 -2731714648976916480 5 IJRLL u t
NULL i ZDPHP what 8 h -609353728 u tell NULL all why i 5 -2309783658887643136 -447479808 1794402976530432000 -5135792425062629376 one j NOZRH
NULL x could was -1362362368 PJDZV 1 i URSPR NULL GRPQU at k 6 -7964897415981432832 1017315328 6 7 ok i j
8 m JWAGE no NULL to 0 w CNEMI 6 BRRIF got u 7 3 0 1 1 p a d
NULL x WPTIG why 6 QIGWE 8 f u 7 n then t 8 0 -748224512 8820862820158537728 -5981906205054861312 HJWPU q BZPOM
-4702602435904929792 d you really NULL TQVBJ 8 c a NULL how x o 9 NULL -280166400 -7567454748865986560 4133178558019272704 r w with
0 m this MSYSE 9 c 1507065856 v v 606601216 one j d 10 1 3 9 3 r p it
2 c HUYRF UEZQE 1515061248 well 4 x z NULL r JYCYO q 11 NULL 416415744 5 3220073733569904640 LOOQX v XCGOH
-3214725709012402176 t BWCQX w 2 EBGJZ 1524367360 e have 534904832 say QADUT q 12 4 5 6442680741930205184 -7162975207332773888 with q no
NULL f VETFO OCGPF -219217920 VXUGM 8 w OGLVA 8 will JRZIM e 13 NULL -721027072 -8546987667819069440 4 HEPKH f a
6 j some KKWBL NULL NFPET 8 a didn't NULL f from k 14 5784873721357402112 6 2771402620693118976 -3209377684454899712 a v FEKXH
NULL m l ERGSH NULL this 8 g have 4 oh l y 15 NULL 5 -4316137292881199104 3830874433032028160 f d u
6 e I'll h 9 why 1903689728 s USBHU 8 URBRY q b 16 3 9 2 6 l d XEUHW
-4108127285092024320 f b WMPKH 7 c 178520064 r XIHTV 1119158272 could ANVSO x 17 3 9 1443966630525665280 2 x p i
NULL d f have 763953152 a 4 w w -875102208 l a x 18 6 -1990328320 7 6345008925011607552 from b PTZYO
NULL q e didn't NULL well 1973485568 t EJXKT -1814364160 IUDZN ASBVO v 19 6 1733361664 7 2 MHDLC e q
7447827883763957760 a j e -771620864 i 973144064 n f 46727168 u because f 20 8 9 4 3 ITBED j u
1568941520185196544 g SLDZX DYQRN 5 g 2 x UOYXK -2097610752 it's from m 21 NULL -1349844992 5221923767936090112 -8438901276762177536 VFCRO f TTNNK
NULL g l i NULL k 1130889216 x q 1 m DXSWH h 22 7789257030513983488 2056716288 0 -6883189080482381824 i n z
8 k then RRXXD 1104019456 u 2 l had NULL t BVGQA m 23 -4929471267133718528 659619840 1279022294173220864 887772076545409024 JZBYO t why
NULL z like she NULL d 680329216 d OLKNI -1310916608 d up n 24 -4552294798341439488 5 5 4 mean y RDNAH
6 k all b -2054946816 u 3 u your 2024996864 l KZOIW m 25 1 162856960 8270860715665915904 5 GUIUY e go
6556396632521310208 k is PDNXO 476315648 XPLMI 1707212800 a l NULL SXUOG m m 26 -6770880564774830080 -154402816 -6301661778598166528 -6796776262632210432 would l at
NULL p GHWYO QBEEI 0 f 226557952 i DBSXY -2028666880 i GNWDR d 27 5 0 3 -2258836688103014400 n f b
3533355382648864768 a KDXMJ are NULL VMLJU 2 p QPCRJ NULL c now w 28 NULL 0 6 -1995939059855261696 b w your
NULL l b when 2 VCLTM 33751040 v q 747110400 VNMTO y b 29 5 6 5818650718562680832 -8166714974282973184 o i TKIIP
NULL k TVNFL he's NULL e 1454112768 g m 1 y v a 30 0 -356384768 6 0 z v h
9 x CLGFS a NULL f 8 e v 7 d get p 31 0 1 -5241345541329125376 6451687941184946176 it c o
4 g w I NULL x -370081792 m e 0 CHXCP mean a 32 9 -1495400448 5 353814045725294592 t d c
NULL u KPDSD a 6 GEDEE 1637154816 z RORBZ 6 now SLTKG x 33 -7162130782402641920 9 9 3 mean p did
NULL e i XVHGM NULL time 97517568 z LJWJL 4 who there d 34 NULL 5 1847601747128745984 2 think o then
-5505087594507010048 p l h 8 u -2111242240 j with 6 p MTQOR a 35 5580804363242176512 3 2 -7699747987919994880 TDARB o o
3465238438284886016 v JBPUP ZSHTA -1207828480 a 2 m KXCXD 9 h f w 36 3 7 1 5 you're y can
NULL x don't c 5 LHQZG 50003968 w HGQLX NULL n or u 37 NULL -1414135808 6938358175917670400 9 o f GPPDO
NULL v IEPYU a 1920008192 FXOJE 1985150976 a IOBFS NULL k j a 38 NULL -2143485952 2732840548883759104 3187985586224889856 right y XXZAH
-646266546527666176 f VSBWR could 800915456 APRXR 9 r d -1298137088 will when t 39 NULL 1822883840 1 3 there a s
NULL p ZAZJK TSIEI 1 how 120061952 s SDADP -704184320 can a w 40 3884073203630342144 7 0 7 TWWGS j UFYRK
7 x d UMFYV 1462960128 no -1078001664 w from 1795620864 m CXCAX j 41 -7156219807891718144 8 9 3377699720527872000 her u UKIUK
1704893933936443392 l q w 2 don't 909770752 w something NULL j c n 42 3 9 4 5 x m b
-8849854742759735296 e oh y NULL who -1872166912 l ZFBVI -1316356096 YOFSX her r 43 -8150389425633755136 -1386610688 0 -33776997205278720 something w EIUSF
-1878563994566918144 m i EDVII NULL say 819396608 c GMESX 791019520 UPVRS but e 44 NULL 7 8794404172347736064 2413084975340453888 w p here
4 i x h NULL f 141099008 h one -1709572096 RIICG like u 45 6 1 5 7 you k c
-76842668642009088 h EXZPO PFYHG NULL UBPGM 9 g here -1922957312 JBOWU w x 46 8 1352466432 1 9 I'll f KAQCG
7 w o at NULL v 5 t good NULL would IQUAV q 47 8 1 5 -6735414717709287424 m e RWJSL
8990592231115063296 f v OGNJD NULL KPOBP -579731456 i u NULL that's really i 48 3 -621150208 9 -7248262125276102656 y l but
NULL t good HEFMW 9 PNINW 7 k d 463863808 m a t 49 3 1192755200 9 -2311753983724617728 KEVRQ l HZMCU
8 z some w NULL KUJES -2143551488 u EOYYW 5 FIUID s n 50 6 4 8 721138890332700672 q l OLIZZ
SHOW CREATE TABLE A;
Table Create Table
A CREATE TABLE `A` (
`col_bigint` BIGINT DEFAULT NULL,
`col_enum` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
`col_char_10` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
`col_char_1024` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,
`col_int` INT DEFAULT NULL,
`col_char_10_not_null` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,
`col_int_not_null_key` INT NOT NULL,
`col_enum_not_null` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
`col_char_1024_not_null_key` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL,
`col_int_key` INT DEFAULT NULL,
`col_char_10_key` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
`col_char_1024_not_null` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL,
`col_enum_not_null_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
`pk` INT NOT NULL AUTO_INCREMENT,
`col_bigint_key` BIGINT DEFAULT NULL,
`col_int_not_null` INT NOT NULL,
`col_bigint_not_null` BIGINT NOT NULL,
`col_bigint_not_null_key` BIGINT NOT NULL,
`col_char_10_not_null_key` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,
`col_enum_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
`col_char_1024_key` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`pk`),
KEY `col_int_not_null_key` (`col_int_not_null_key`),
KEY `col_char_1024_not_null_key` (`col_char_1024_not_null_key`(255)),
KEY `col_int_key` (`col_int_key`),
KEY `col_char_10_key` (`col_char_10_key`),
KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
KEY `col_bigint_key` (`col_bigint_key`),
KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
KEY `col_enum_key` (`col_enum_key`),
KEY `col_char_1024_key` (`col_char_1024_key`(255))
) ENGINE=InnoDB COLLATE = utf8_general_ci
DROP TABLE A;
|