archive.result

这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置

drop table if exists t1,t2;
CREATE TABLE t1 (
Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL
) ENGINE=archive;
INSERT INTO t1 VALUES (9410,9412);
select period from t1;
period
9410
select * from t1;
Period	Varor_period
9410	9412
select t1.* from t1;
Period	Varor_period
9410	9412
CREATE TABLE t2 (
auto int,
fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL,
companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL,
fld3 char(30) DEFAULT '' NOT NULL,
fld4 char(35) DEFAULT '' NOT NULL,
fld5 char(35) DEFAULT '' NOT NULL,
fld6 char(4) DEFAULT '' NOT NULL
) ENGINE=archive;
select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";
fld3
imaginable
select fld3 from t2 where fld3 like "%cultivation" ;
fld3
cultivation
select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3;
fld3	companynr
concoct	58
druggists	58
engrossing	58
Eurydice	58
exclaimers	58
ferociousness	58
hopelessness	58
Huey	58
imaginable	58
judges	58
merging	58
ostrich	58
peering	58
Phelps	58
presumes	58
Ruth	58
sentences	58
Shylock	58
straggled	58
synergy	58
thanking	58
tying	58
unlocks	58
select fld3,companynr from t2 where companynr = 58 order by fld3;
fld3	companynr
concoct	58
druggists	58
engrossing	58
Eurydice	58
exclaimers	58
ferociousness	58
hopelessness	58
Huey	58
imaginable	58
judges	58
merging	58
ostrich	58
peering	58
Phelps	58
presumes	58
Ruth	58
sentences	58
Shylock	58
straggled	58
synergy	58
thanking	58
tying	58
unlocks	58
select fld3 from t2 order by fld3 desc limit 10;
fld3
youthfulness
yelped
Wotan
workers
Witt
witchcraft
Winsett
Willy
willed
wildcats
select fld3 from t2 order by fld3 desc limit 5;
fld3
youthfulness
yelped
Wotan
workers
Witt
select fld3 from t2 order by fld3 desc limit 5,5;
fld3
witchcraft
Winsett
Willy
willed
wildcats
select t2.fld3 from t2 where fld3 = 'honeysuckle';
fld3
honeysuckle
select t2.fld3 from t2 where fld3 LIKE 'honeysuckl_';
fld3
honeysuckle
select t2.fld3 from t2 where fld3 LIKE 'hon_ysuckl_';
fld3
honeysuckle
select t2.fld3 from t2 where fld3 LIKE 'honeysuckle%';
fld3
honeysuckle
select t2.fld3 from t2 where fld3 LIKE 'h%le';
fld3
honeysuckle
select t2.fld3 from t2 where fld3 LIKE 'honeysuckle_';
fld3
select t2.fld3 from t2 where fld3 LIKE 'don_t_find_me_please%';
fld3
select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;
fld3
honeysuckle
honoring
select fld1,fld3 from t2 where fld3="Colombo" or fld3 = "nondecreasing" order by fld3;
fld1	fld3
148504	Colombo
068305	Colombo
000000	nondecreasing
select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%';
fld1	fld3
012001	flanking
013602	foldout
013606	fingerings
018007	fanatic
018017	featherweight
018054	fetters
018103	flint
018104	flopping
036002	funereal
038017	fetched
038205	firearm
058004	Fenton
088303	feminine
186002	freakish
188007	flurried
188505	fitting
198006	furthermore
202301	Fitzpatrick
208101	fiftieth
208113	freest
218008	finishers
218022	feed
218401	faithful
226205	foothill
226209	furnishings
228306	forthcoming
228311	fated
231315	freezes
232102	forgivably
238007	filial
238008	fixedly
select fld3 from t2 where fld3 like "L%" and fld3 = "ok";
fld3
select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly");
fld3
Chantilly
select fld1,fld3 from t2 where fld1 like "25050%";
fld1	fld3
250501	poisoning
250502	Iraqis
250503	heaving
250504	population
250505	bomb
select fld1,fld3 from t2 where fld1 like "25050_";
fld1	fld3
250501	poisoning
250502	Iraqis
250503	heaving
250504	population
250505	bomb
create table t3 engine=archive select * from t2;
select * from t3 where fld3='bonfire';
auto	fld1	companynr	fld3	fld4	fld5	fld6
1191	068504	00	bonfire	corresponds	positively	
select count(*) from t3;
count(*)
1199
rename table t3 to t4;
select * from t4 where fld3='bonfire';
auto	fld1	companynr	fld3	fld4	fld5	fld6
1191	068504	00	bonfire	corresponds	positively	
select count(*) from t4;
count(*)
1199
INSERT INTO t2 VALUES (1,000001,00,'Omaha','teethe','neat','');
INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
SELECT * FROM t2;
auto	fld1	companynr	fld3	fld4	fld5	fld6
1	000001	00	Omaha	teethe	neat	
2	011401	37	breaking	dreaded	Steinberg	W
3	011402	37	Romans	scholastics	jarring	
4	011403	37	intercepted	audiology	tinily	
5	011501	37	bewilderingly	wallet	balled	
6	011701	37	astound	parters	persist	W
7	011702	37	admonishing	eschew	attainments	
8	011703	37	sumac	quitter	fanatic	
9	012001	37	flanking	neat	measures	FAS
10	012003	37	combed	Steinberg	rightfulness	
11	012004	37	subjective	jarring	capably	
12	012005	37	scatterbrain	tinily	impulsive	
13	012301	37	Eulerian	balled	starlet	
14	012302	36	dubbed	persist	terminators	
15	012303	37	Kane	attainments	untying	
16	012304	37	overlay	fanatic	announces	FAS
17	012305	37	perturb	measures	featherweight	FAS
18	012306	37	goblins	rightfulness	pessimist	FAS
19	012501	37	annihilates	capably	daughter	
20	012602	37	Wotan	impulsive	decliner	FAS
21	012603	37	snatching	starlet	lawgiver	
22	012604	37	concludes	terminators	stated	
23	012605	37	laterally	untying	readable	
24	012606	37	yelped	announces	attrition	
25	012701	37	grazing	featherweight	cascade	FAS
26	012702	37	Baird	pessimist	motors	FAS
27	012703	37	celery	daughter	interrogate	
28	012704	37	misunderstander	decliner	pests	W
29	013601	37	handgun	lawgiver	stairway	
30	013602	37	foldout	stated	dopers	FAS
31	013603	37	mystic	readable	testicle	W
32	013604	37	succumbed	attrition	Parsifal	W
33	013605	37	Nabisco	cascade	leavings	
34	013606	37	fingerings	motors	postulation	W
35	013607	37	aging	interrogate	squeaking	
36	013608	37	afield	pests	contrasted	
37	013609	37	ammonium	stairway	leftover	
38	013610	37	boat	dopers	whiteners	
39	013801	37	intelligibility	testicle	erases	W
40	013802	37	Augustine	Parsifal	Punjab	W
41	013803	37	teethe	leavings	Merritt	
42	013804	37	dreaded	postulation	Quixotism	
43	013901	37	scholastics	squeaking	sweetish	FAS
44	016001	37	audiology	contrasted	dogging	FAS
45	016201	37	wallet	leftover	scornfully	FAS
46	016202	37	parters	whiteners	bellow	
47	016301	37	eschew	erases	bills	
48	016302	37	quitter	Punjab	cupboard	FAS
49	016303	37	neat	Merritt	sureties	FAS
50	016304	37	Steinberg	Quixotism	puddings	
51	018001	37	jarring	sweetish	tapestry	
52	018002	37	tinily	dogging	fetters	
53	018003	37	balled	scornfully	bivalves	
54	018004	37	persist	bellow	incurring	
55	018005	37	attainments	bills	Adolph	
56	018007	37	fanatic	cupboard	pithed	
57	018008	37	measures	sureties	emergency	
58	018009	37	rightfulness	puddings	Miles	
59	018010	37	capably	tapestry	trimmings	
60	018012	37	impulsive	fetters	tragedies	W
61	018013	37	starlet	bivalves	skulking	W
62	018014	37	terminators	incurring	flint	
63	018015	37	untying	Adolph	flopping	W
64	018016	37	announces	pithed	relaxing	FAS
65	018017	37	featherweight	emergency	offload	FAS
66	018018	37	pessimist	Miles	suites	W
67	018019	37	daughter	trimmings	lists	FAS
68	018020	37	decliner	tragedies	animized	FAS
69	018021	37	lawgiver	skulking	multilayer	W
70	018022	37	stated	flint	standardizes	FAS
71	018023	37	readable	flopping	Judas	
72	018024	37	attrition	relaxing	vacuuming	W
73	018025	37	cascade	offload	dentally	W
74	018026	37	motors	suites	humanness	W
75	018027	37	interrogate	lists	inch	W
76	018028	37	pests	animized	Weissmuller	W
77	018029	37	stairway	multilayer	irresponsibly	W
78	018030	37	dopers	standardizes	luckily	FAS
79	018032	37	testicle	Judas	culled	W
80	018033	37	Parsifal	vacuuming	medical	FAS
81	018034	37	leavings	dentally	bloodbath	FAS
82	018035	37	postulation	humanness	subschema	W
83	018036	37	squeaking	inch	animals	W
84	018037	37	contrasted	Weissmuller	Micronesia	
85	018038	37	leftover	irresponsibly	repetitions	
86	018039	37	whiteners	luckily	Antares	
87	018040	37	erases	culled	ventilate	W
88	018041	37	Punjab	medical	pityingly	
89	018042	37	Merritt	bloodbath	interdependent	
90	018043	37	Quixotism	subschema	Graves	FAS
91	018044	37	sweetish	animals	neonatal	
92	018045	37	dogging	Micronesia	scribbled	FAS
93	018046	37	scornfully	repetitions	chafe	W
94	018048	37	bellow	Antares	honoring	
95	018049	37	bills	ventilate	realtor	
96	018050	37	cupboard	pityingly	elite	
97	018051	37	sureties	interdependent	funereal	
98	018052	37	puddings	Graves	abrogating	
99	018053	50	tapestry	neonatal	sorters	
100	018054	37	fetters	scribbled	Conley	
101	018055	37	bivalves	chafe	lectured	
102	018056	37	incurring	honoring	Abraham	
103	018057	37	Adolph	realtor	Hawaii	W
104	018058	37	pithed	elite	cage	
105	018059	36	emergency	funereal	hushes	
106	018060	37	Miles	abrogating	Simla	
107	018061	37	trimmings	sorters	reporters	
108	018101	37	tragedies	Conley	Dutchman	FAS
109	018102	37	skulking	lectured	descendants	FAS
110	018103	37	flint	Abraham	groupings	FAS
111	018104	37	flopping	Hawaii	dissociate	
112	018201	37	relaxing	cage	coexist	W
113	018202	37	offload	hushes	Beebe	
114	018402	37	suites	Simla	Taoism	
115	018403	37	lists	reporters	Connally	
116	018404	37	animized	Dutchman	fetched	FAS
117	018405	37	multilayer	descendants	checkpoints	FAS
118	018406	37	standardizes	groupings	rusting	
119	018409	37	Judas	dissociate	galling	
120	018601	37	vacuuming	coexist	obliterates	
121	018602	37	dentally	Beebe	traitor	
122	018603	37	humanness	Taoism	resumes	FAS
123	018801	37	inch	Connally	analyzable	FAS