drop table if exists t1,t2,t3,t4;
CREATE TABLE t1 (
Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL
) ENGINE = CSV;
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 not null,
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 = CSV;
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
UPDATE t2 SET fld3="foo" WHERE fld3="b%";
select fld3 from t2;
fld3
Omaha
breaking
Romans
intercepted
bewilderingly
astound
admonishing
sumac
flanking
combed
subjective
scatterbrain
Eulerian
dubbed
Kane
overlay
perturb
goblins
annihilates
Wotan
snatching
concludes
laterally
yelped
grazing
Baird
celery
misunderstander
handgun
foldout
mystic
succumbed
Nabisco
fingerings
aging
afield
ammonium
boat
intelligibility
Augustine
teethe
dreaded
scholastics
audiology
wallet
parters
eschew
quitter
neat
Steinberg
jarring
tinily
balled
persist
attainments
fanatic
measures
rightfulness
capably
impulsive
starlet
terminators
untying
announces
featherweight
pessimist
daughter
decliner
lawgiver
stated
readable
attrition
cascade
motors
interrogate
pests
stairway
dopers
testicle
Parsifal
leavings
postulation
squeaking
contrasted
leftover
whiteners
erases
Punjab
Merritt
Quixotism
sweetish
dogging
scornfully
bellow
bills
cupboard
sureties
puddings
tapestry
fetters
bivalves
incurring
Adolph
pithed
emergency
Miles
trimmings
tragedies
skulking
flint
flopping
relaxing
offload
suites
lists
animized
multilayer
standardizes
Judas
vacuuming
dentally
humanness
inch
Weissmuller
irresponsibly
luckily
culled
medical
bloodbath
subschema
animals
Micronesia
repetitions
Antares
ventilate
pityingly
interdependent
Graves
neonatal
scribbled
chafe
honoring
realtor
elite
funereal
abrogating
sorters
Conley
lectured
Abraham
Hawaii
cage
hushes
Simla
reporters
Dutchman
descendants
groupings
dissociate
coexist
Beebe
Taoism
Connally
fetched
checkpoints
rusting
galling
obliterates
traitor
resumes
analyzable
terminator
gritty
firearm
minima
Selfridge
disable
witchcraft
betroth
Manhattanize
imprint
peeked
swelling
interrelationships
riser
Gandhian
peacock
bee
kanji
dental
scarf
chasm
insolence
syndicate
alike
imperial
convulsion
railway
validate
normalizes
comprehensive
chewing
denizen
schemer
chronicle
Kline
Anatole
partridges
brunch
recruited
dimensions
Chicana
announced
praised
employing
linear
quagmire
western
relishing
serving
scheduling
lore
eventful
arteriole
disentangle
cured
Fenton
avoidable
drains
detectably
husky
impelling
undoes
evened
squeezes
destroyer
rudeness
beaner
boorish
Everhart
encompass
mushrooms
Alison
externally
pellagra
cult
creek
Huffman
Majorca
governing
gadfly
reassigned
intentness
craziness
psychic
squabbled
burlesque
capped
extracted
DiMaggio
exclamation
subdirectory
fangs
buyer
pithing
transistorizing
nonbiodegradable
dislocate
monochromatic
batting
postcondition
catalog
Remus
devices
bike
qualify
detained
commended
civilize
Elmhurst
anesthetizing
deaf
Brigham
title
coarse
combinations
grayness
innumerable
Caroline
fatty
eastbound
inexperienced
hoarder
scotch
passport
strategic
gated
flog
Pipestone
Dar
Corcoran
flyers
competitions
suppliers
skips
institutes
troop
connective
denies
polka
observations
askers
homeless
Anna
subdirectories
decaying
outwitting
Harpy
crazed
suffocate
provers
technically
Franklinizations
considered
tinnily
uninterruptedly
whistled
automate
gutting
surreptitious
Choctaw
cooks
millivolt
counterpoise
Gothicism
feminine
metaphysically
sanding
contributorily
receivers
adjourn
straggled
druggists
thanking
ostrich
hopelessness
Eurydice
excitation
presumes
imaginable
concoct
peering
Phelps
ferociousness
sentences
unlocks
engrossing
Ruth
tying
exclaimers
synergy
Huey
merging
judges
Shylock
Miltonism
hen
honeybee
towers
dilutes
numerals
democracy
Ibero-
invalids
behavior
accruing
relics
rackets
Fischbein
phony
cross
cleanup
conspirator
label
university
cleansed
ballgown
starlet
aqueous
portrayal
despising
distort
palmed
faced
silverware
assessor
spiders
artificially
reminiscence
Mexican
obnoxious
fragile
apprehensible
births
garages
panty
anteater
displacement
drovers
patenting
far
shrieks
aligning
pragmatism
fevers
reexamines
occupancies
sweats
modulators
demand
Madeira
Viennese
chillier
wildcats
gentle
Angles
accuracies
toggle
Mendelssohn
behaviorally
Rochford
mirror
Modula
clobbering
chronography
Eskimoizeds
British
pitfalls
verify
scatter
Aztecan
acuity
sinking
beasts
Witt
physicists
folksong
strokes
crowder
merry
cadenced
alimony
principled
golfing
undiscovered
irritates
patriots
rooms
towering
displease
photosensitive
inking
gainers
leaning
hydrant
preserve
blinded
interactions
Barry
whiteness
pastimes
Edenization
Muscat
assassinated
labeled
glacial
implied
bibliographies
Buchanan
forgivably
innuendo
den
submarines
mouthful
expiring
unfulfilled
precession
nullified
affects
Cynthia
Chablis
betterments
advertising
rubies
southwest
superstitious
tabernacle
silk
handsomest
Persian
analog
complex
Taoist
suspend
relegated
awesome
Bruxelles
imprecisely
televise
braking
true
disappointing
navally
circus
beetles
trumps
fourscore
Blackfoots
Grady
quiets
floundered
profundity
Garrisonian
Strauss
cemented
contrition
mutations
exhibits
tits
mate
arches
Moll
ropers
bombast
difficultly
adsorption
definiteness
cultivation
heals
Heusen
target
cited
congresswoman
Katherine
titter
aspire
Mardis
Nadia
estimating
stuck
fifteenth
Colombo
survey
staffing
obtain
loaded
slaughtered
lights
circumference
dull
weekly
wetness
visualized
Tannenbaum
moribund
demultiplex
lockings
thugs
unnerves
abut
Chippewa
stratifications
signaled
Italianizes
algorithmic
paranoid
camping
signifying
Patrice
search
Angeles
semblance
taxed
Beatrice
retrace
lockout
grammatic
helmsman
uniform
hamming
disobedience
captivated
transferals
cartographer
aims
Pakistani
burglarized
saucepans
lacerating
corny
megabytes
chancellor
bulk
commits
meson
deputies
northeaster
dipole
machining
therefore
Telefunken
salvaging
Corinthianizes
restlessly
bromides
generalized
mishaps
quelling
spiritual
beguiles
Trobriand
fleeing
Armour
chin
provers
aeronautic
voltage
sash
anaerobic
simultaneous
accumulating
Medusan
shouted
freakish
index
commercially
mistiness
endpoint
straight
flurried
denotative
coming
commencements
gentleman
gifted
Shanghais
sportswriting
sloping
navies
leaflet
shooter
Joplin
babies
subdivision
burstiness
belted
assails
admiring
swaying
Goldstine
fitting
Norwalk
weakening
analogy
deludes
cokes
Clayton
exhausts
causality
sating
icon
throttles
communicants
dehydrate
priceless
publicly
incidentals
commonplace
mumbles
furthermore
cautioned
parametrized
registration
sadly
positioning
babysitting
eternal
hoarder
congregates
rains
workers
sags
unplug
garage
boulder
hollowly
specifics
Teresa
Winsett
convenient
buckboards
amenities
resplendent
priding
configurations
untidiness
Brice
sews
participated
Simon
certificates
Fitzpatrick
Evanston
misted
textures
save
count
rightful
chaperone
Lizzy
clenched
effortlessly
accessed
beaters
Hornblower
vests
indulgences
infallibly
unwilling
excrete
spools
crunches
overestimating
ineffective
humiliation
sophomore
star
rifles
dialysis
arriving
indulge
clockers
languages
Antarctica
percentage
ceiling
specification
regimented
ciphers
pictures
serpents
allot
realized
mayoral
opaquely
hostess
fiftieth
incorrectly
decomposition
stranglings
mixture
electroencephalography
similarities
charges
freest
Greenberg
tinting
expelled
warm
smoothed
deductions
Romano
bitterroot
corset
securing
environing
cute
Crays
heiress
inform
avenge
universals
Kinsey
ravines
bestseller
equilibrium
extents
relatively
pressure
critiques
befouled
rightfully
mechanizing
Latinizes
timesharing
Aden
embassies
males
shapelessly
genres
mastering
Newtonian
finishers
abates
teem
kiting
stodgy
scalps
feed
guitars
airships
store
denounces
Pyle
Saxony
serializations
Peruvian
taxonomically
kingdom
stint
Sault
faithful
Ganymede
tidiness
gainful
contrary
Tipperary
tropics
theorizers
renew
already
terminal
Hegelian
hypothesizer
warningly
journalizing
nested
Lars
saplings
foothill
labeled
imperiously
reporters
furnishings
precipitable
discounts
excises
Stalin
despot
ripeness
Arabia
unruly
mournfulness
boom
slaughter
Sabine
handy
rural
organizer
shipyard
civics
inaccuracy
rules
juveniles
comprised
investigations
stabilizes
seminaries
Hunter
sporty
test
weasels
CERN
tempering
afore
Galatean
techniques
error
veranda
severely
Cassites
forthcoming
guides
vanish
lied
sawtooth
fated
gradually
widens
preclude
Jobrel
hooker
rainstorm
disconnects
cruelty
exponentials
affective
arteries
Crosby
acquaint
evenhandedly
percentage
disobedience
humility
gleaning
petted
bloater
minion
marginal
apiary
measures
precaution
repelled
primary
coverings
Artemia
navigate
spatial
Gurkha
meanwhile
Melinda
Butterfield
Aldrich
previewing
glut
unaffected
inmate
mineral
impending
meditation
ideas
miniaturizes
lewdly
title
youthfulness
creak
Chippewa
clamored
freezes
forgivably
reduce
McGovern
Nazis
epistle
socializes
conceptions
Kevin
uncovering
chews
appendixes
appendixes
appendixes
appendixes
appendixes
appendixes
raining
infest
compartment
minting
ducks
roped
waltz
Lillian
repressions
chillingly
noncritical
lithograph
spongers
parenthood
posed
instruments
filial
fixedly
relives
Pandora
watering
ungrateful
secures
chastisers
icon
reuniting
imagining
abiding
omnisciently
Britannic
scholastics
mechanics
humidly
masterpiece
however
Mendelian
jarred
scolds
infatuate
willed
joyfully
Microsoft
fibrosities
Baltimorean
equestrian
Goodrich
apish
Adlerian
Tropez
nouns
distracting
mutton
bridgeable
stickers
transcontinental
amateurish
Gandhian
stratified
chamberlains
creditably
philosophic
ores
Carleton
tape
afloat
goodness
welcoming
Pinsky
halting
bibliography
decoding
variance
allowed
dire
dub
poisoning
Iraqis
heaving
population
bomb
Majorca
Gershwins
explorers
libretto
occurred
Lagos
rats
bankruptcies
crying
unexpected
accessed
colorful
versatility
cosy
Darius
mastering
Asiaticizations
offerers
uncles
sleepwalk
Ernestine
checksumming
stopped
sicker
Italianization
alphabetic
pharmaceutic
creator
chess
charcoal
Epiphany
bulldozes
Pygmalion
caressing
Palestine
regimented
scars
realest
diffusing
clubroom
Blythe
ahead
reviver
retransmitting
landslide
Eiffel
absentee
aye
forked
Peruvianizes
clerked
tutor
boulevard
shuttered
quotes
Caltech
Mossberg
kept
roundly
features
imaginable
controller
racial
uprisings
narrowed
cannot
vest
famine
sugars
exterminated
belays
Hodges
translatable
duality
recording
rouses
poison
attitude
dusted
encompasses
presentation
Kantian
imprecision
saving
maternal
hewed
kerosene
Cubans
photographers
nymph
bedlam
north
Schoenberg
botany
curs
solidification
inheritresses
stiller
t1
suite
ransomer
Willy
Rena
Seattle
relaxes
exclaim
exclaim
implicated
distinguish
assayed
homeowner
and
stealth
coinciding
founder
environing
jewelry
lemons
brokenness
bedpost
assurers
annoyers
affixed
warbling
seriously
boasted
Chantilly
Iranizes
violinist
extramarital
spates
cloakroom
gazer
hand
tucked
gems
clinker
refiner
callus
leopards
comfortingly
generically
getters
sexually
spear
serums
Italianization
attendants
spies
Anthony
planar
cupped
cleanser
commuters
honeysuckle
orphanage
skies
crushers
Puritan
squeezer
bruises
bonfire
Colombo
nondecreasing
UPDATE t2 SET fld3="bar" WHERE fld3="s%";
select fld3 from t2;
fld3
Omaha
breaking
Romans
intercepted
bewilderingly
astound
admonishing
sumac
flanking
combed
subjective
scatterbrain
Eulerian
dubbed
Kane
overlay
perturb
goblins
annihilates
Wotan
snatching
concludes
laterally
yelped
grazing
Baird
celery
misunderstander
handgun
foldout
mystic
succumbed
Nabisco
fingerings
aging
afield
ammonium
boat
intelligibility
Augustine
teethe
dreaded
scholastics
audiology
wallet
parters
eschew
quitter
neat
Steinberg
jarring
tinily
balled
persist
attainments
fanatic
measures
rightfulness
capably
impulsive
starlet
terminators
untying
announces
featherweight
pessimist
daughter
decliner
lawgiver
stated
readable
attrition
cascade
motors
interrogate
pests
stairway
dopers
testicle
Parsifal
leavings
postulation
squeaking
contrasted
leftover
whiteners
erases
Punjab
Merritt
Quixotism
sweetish
dogging
scornfully
bellow
bills
cupboard
sureties
puddings
tapestry
fetters
bivalves
incurring
Adolph
pithed
emergency
Miles
trimmings
tragedies
skulking
flint
flopping
relaxing
offload
suites
lists
animized
multilayer
standardizes
Judas
vacuuming
dentally
humanness
inch
Weissmuller
irresponsibly
luckily
culled
medical
bloodbath
subschema
animals
Micronesia
repetitions
Antares
ventilate
pityingly
interdependent
Graves
neonatal
scribbled
chafe
honoring
realtor
elite
funereal
abrogating
sorters
Conley
lectured
Abraham
Hawaii
cage
hushes
Simla
reporters
Dutchman
descendants
groupings
dissociate
coexist
Beebe
Taoism
Connally
fetched
checkpoints
rusting
galling
obliterates
traitor
resumes
analyzable
terminator
gritty
firearm
minima
Selfridge
disable
witchcraft
betroth
Manhattanize
imprint
peeked
swelling
interrelationships
riser
Gandhian
peacock
bee
kanji
dental
scarf
chasm
insolence
syndicate
alike
imperial
convulsion
railway
validate
normalizes
comprehensive
chewing
denizen
schemer
chronicle
Kline
Anatole
partridges
brunch
recruited
dimensions
Chicana
announced
praised
employing
linear
quagmire
western
relishing
serving
scheduling
lore
eventful
arteriole
disentangle
cured
Fenton
avoidable
drains
detectably
husky
impelling
undoes
evened
squeezes
destroyer
rudeness
beaner
boorish
Everhart
encompass
mushrooms
Alison
externally
pellagra
cult
creek
Huffman
Majorca
governing
gadfly
reassigned
intentness
craziness
psychic
squabbled
burlesque
capped
extracted
DiMaggio
exclamation
subdirectory
fangs
buyer
pithing
transistorizing
nonbiodegradable
dislocate
monochromatic
batting
postcondition
catalog
Remus
devices
bike
qualify
detained
commended
civilize
Elmhurst
anesthetizing
deaf
Brigham
title
coarse
combinations
grayness
innumerable
Caroline
fatty
eastbound
inexperienced
hoarder
scotch
passport
strategic
gated
flog
Pipestone
Dar
Corcoran
flyers
competitions
suppliers
skips
institutes
troop
connective
denies
polka
observations
askers
homeless
Anna
subdirectories
decaying
outwitting
Harpy
crazed
suffocate
provers
technically
Franklinizations
considered
tinnily
uninterruptedly
whistled
automate
gutting
surreptitious
Choctaw
cooks
millivolt
counterpoise
Gothicism
feminine
metaphysically
sanding
contributorily
receivers
adjourn
straggled
druggists
thanking
ostrich
hopelessness
Eurydice
excitation
presumes
imaginable
concoct
peering
Phelps
ferociousness
sentences
unlocks
engrossing
Ruth
tying
exclaimers
synergy
Huey
merging
judges
Shylock
Miltonism
hen
honeybee
towers
dilutes
numerals
democracy
Ibero-
invalids
behavior
accruing
relics
rackets
Fischbein
phony
cross
cleanup
conspirator
label
university
cleansed
ballgown
starlet
aqueous
portrayal
despising
distort
palmed
faced
silverware
assessor
spiders
artificially
reminiscence
Mexican
obnoxious
fragile
apprehensible
births
garages
panty
anteater
displacement
drovers
patenting
far
shrieks
aligning
pragmatism
fevers
reexamines
occupancies
sweats
modulators
demand
Madeira
Viennese
chillier
wildcats
gentle
Angles
accuracies
toggle
Mendelssohn
behaviorally
Rochford
mirror
Modula
clobbering
chronography
Eskimoizeds
British
pitfalls
verify
scatter
Aztecan
acuity
sinking
beasts
Witt
physicists
folksong
strokes
crowder
merry
cadenced
alimony
principled
golfing
undiscovered
irritates
patriots
rooms
towering
displease
photosensitive
inking
gainers
leaning
hydrant
preserve
blinded
interactions
Barry
whiteness
pastimes
Edenization
Muscat
assassinated
labeled
glacial
implied
bibliographies
Buchanan
forgivably
innuendo
den
submarines
mouthful
expiring
unfulfilled
precession
nullified
affects
Cynthia
Chablis
betterments
advertising
rubies
southwest
superstitious
tabernacle
silk
handsomest
Persian
analog
complex
Taoist
suspend
relegated
awesome
Bruxelles
imprecisely
televise
braking
true
disappointing
navally
circus
beetles
trumps
fourscore
Blackfoots
Grady
quiets
floundered
profundity
Garrisonian
Strauss
cemented
contrition
mutations
exhibits
tits
mate
arches
Moll
ropers
bombast
difficultly
adsorption
definiteness
cultivation
heals
Heusen
target
cited
congresswoman
Katherine
titter
aspire
Mardis
Nadia
estimating
stuck
fifteenth
Colombo
survey
staffing
obtain
loaded
slaughtered
lights
circumference
dull
weekly
wetness
visualized
Tannenbaum
moribund
demultiplex
lockings
thugs
unnerves
abut
Chippewa
stratifications
signaled
Italianizes
algorithmic
paranoid
camping
signifying
Patrice
search
Angeles
semblance
taxed
Beatrice
retrace
lockout
grammatic
helmsman
uniform
hamming
disobedience
captivated
transferals
cartographer
aims
Pakistani
burglarized
saucepans
lacerating
corny
megabytes
chancellor
bulk
commits
meson
deputies
northeaster
dipole
machining
therefore
Telefunken
salvaging
Corinthianizes
restlessly
bromides
generalized
mishaps
quelling
spiritual
beguiles
Trobriand
fleeing
Armour
chin
provers
aeronautic
voltage
sash
anaerobic
simultaneous
accumulating
Medusan
shouted
freakish
index
commercially
mistiness
endpoint
straight
flurried
denotative
coming
commencements
gentleman
gifted
Shanghais
sportswriting
sloping
navies
leaflet
shooter
Joplin
babies
subdivision
burstiness
belted
assails
admiring
swaying
Goldstine
fitting
Norwalk
weakening
analogy
deludes
cokes
Clayton
exhausts
causality
sating
icon
throttles
communicants
dehydrate
priceless
publicly
incidentals
commonplace
mumbles
furthermore
cautioned
parametrized
registration
sadly
positioning
babysitting
eternal
hoarder
congregates
rains
workers
sags
unplug
garage
boulder
hollowly
specifics
Teresa
Winsett
convenient
buckboards
amenities
resplendent
priding
configurations
untidiness
Brice
sews
participated
Simon
certificates
Fitzpatrick
Evanston
misted
textures
save
count
rightful
chaperone
Lizzy
clenched
effortlessly
accessed
beaters
Hornblower
vests
indulgences
infallibly
unwilling
excrete
spools
crunches
overestimating
ineffective
humiliation
sophomore
star
rifles
dialysis
arriving
indulge
clockers
languages
Antarctica
percentage
ceiling
specification
regimented
ciphers
pictures
serpents
allot
realized
mayoral
opaquely
hostess
fiftieth
incorrectly
decomposition
stranglings
mixture
electroencephalography
similarities
charges
freest
Greenberg
tinting
expelled
warm
smoothed
deductions
Romano
bitterroot
corset
securing
environing
cute
Crays
heiress
inform
avenge
universals
Kinsey
ravines
bestseller
equilibrium
extents
relatively
pressure
critiques
befouled
rightfully
mechanizing
Latinizes
timesharing
Aden
embassies
males
shapelessly
genres
mastering
Newtonian
finishers
abates
teem
kiting
stodgy
scalps
feed
guitars
airships
store
denounces
Pyle
Saxony
serializations
Peruvian
taxonomically
kingdom
stint
Sault
faithful
Ganymede
tidiness
gainful
contrary
Tipperary
tropics
theorizers
renew
already
terminal
Hegelian
hypothesizer
warningly
journalizing
nested
Lars
saplings
foothill
labeled
imperiously
reporters
furnishings
precipitable
discounts
excises
Stalin
despot
ripeness
Arabia
unruly
mournfulness
boom
slaughter
Sabine
handy
rural
organizer
shipyard
civics
inaccuracy
rules
juveniles
comprised
investigations
stabilizes
seminaries
Hunter
sporty
test
weasels
CERN
tempering
afore
Galatean
techniques
error
veranda
severely
Cassites
forthcoming
guides
vanish
lied
sawtooth
fated
gradually
widens
preclude
Jobrel
hooker
rainstorm
disconnects
cruelty
exponentials
affective
arteries
Crosby
acquaint
evenhandedly
percentage
disobedience
humility
gleaning
petted
bloater
minion
marginal
apiary
measures
precaution
repelled
primary
coverings
Artemia
navigate
spatial
Gurkha
meanwhile
Melinda
Butterfield
Aldrich
previewing
glut
unaffected
inmate
mineral
impending
meditation
ideas
miniaturizes
lewdly
title
youthfulness
creak
Chippewa
clamored
freezes
forgivably
reduce
McGovern
Nazis
epistle
socializes
conceptions
Kevin
uncovering
chews
appendixes
appendixes
appendixes
appendixes
appendixes
appendixes
raining
infest
compartment
minting
ducks
roped
waltz
Lillian
repressions
chillingly
noncritical
lithograph
spongers
parenthood
posed
instruments
filial
fixedly
relives
Pandora
watering
ungrateful
secures
chastisers
icon
reuniting
imagining
abiding
omnisciently
Britannic
scholastics
mechanics
humidly
masterpiece
however
Mendelian
jarred
scolds
infatuate
willed
joyfully
Microsoft
fibrosities
Baltimorean
equestrian
Goodrich
apish
Adlerian
Tropez
nouns
distracting
mutton
bridgeable
stickers
transcontinental
amateurish
Gandhian
stratified
chamberlains
creditably
philosophic
ores
Carleton
tape
afloat
goodness
welcoming
Pinsky
halting
bibliography
decoding
variance
allowed
dire
dub
poisoning
Iraqis
heaving
population
bomb
Majorca
Gershwins
explorers
libretto
occurred
Lagos
rats
bankruptcies
crying
unexpected
accessed
colorful
versatility
cosy
Darius
mastering
Asiaticizations
offerers
uncles
sleepwalk
Ernestine
checksumming
stopped
sicker
Italianization
alphabetic
pharmaceutic
creator
chess
charcoal
Epiphany
bulldozes
Pygmalion
caressing
Palestine
regimented
scars
realest
diffusing
clubroom
Blythe
ahead
reviver
retransmitting
landslide
Eiffel
absentee
aye
forked
Peruvianizes
clerked
tutor
boulevard
shuttered
quotes
Caltech
Mossberg
kept
roundly
features
imaginable
controller
racial
uprisings
narrowed
cannot
vest
famine
sugars
exterminated
belays
Hodges
translatable
duality
recording
rouses
poison
attitude
dusted
encompasses
presentation
Kantian
imprecision
saving
maternal
hewed
kerosene
Cubans
photographers
nymph
bedlam
north
Schoenberg
botany
curs
solidification
inheritresses
stiller
t1
suite
ransomer
Willy
Rena
Seattle
relaxes
exclaim
exclaim
implicated
distinguish
assayed
homeowner
and
stealth
coinciding
founder
environing
jewelry
lemons
brokenness
bedpost
assurers
annoyers
affixed
warbling
seriously
boasted
Chantilly
Iranizes
violinist
extramarital
spates
cloakroom
gazer
hand
tucked
gems
clinker
refiner
callus
leopards
comfortingly
generically
getters
sexually
spear
serums
Italianization
attendants
spies
Anthony
planar
cupped
cleanser
commuters
honeysuckle
orphanage
skies
crushers
Puritan
squeezer
bruises
bonfire
Colombo
nondecreasing
DELETE FROM t2 WHERE fld3="r%";
SELECT fld3 FROM t2;
fld3
Omaha
breaking
Romans
intercepted
bewilderingly
astound
admonishing
sumac
flanking
combed
subjective
scatterbrain
Eulerian
dubbed
Kane
overlay
perturb
goblins
annihilates
Wotan
snatching
concludes
laterally
yelped
grazing
Baird
celery
misunderstander
handgun
foldout
mystic
succumbed
Nabisco
fingerings
aging
afield
ammonium
boat
intelligibility
Augustine
teethe
dreaded
scholastics
audiology
wallet
parters
eschew
quitter
neat
Steinberg
jarring
tinily
balled
persist
attainments
fanatic
measures
rightfulness
capably
impulsive
starlet
terminators
untying
announces
featherweight
pessimist
daughter
decliner
lawgiver
stated
readable
attrition
cascade
motors
interrogate
pests
stairway
dopers
testicle
Parsifal
leavings
postulation
squeaking
contrasted
leftover
whiteners
erases
Punjab
Merritt
Quixotism
sweetish
dogging
scornfully
bellow
bills
cupboard
sureties
puddings
tapestry
fetters
bivalves
incurring
Adolph
pithed
emergency
Miles
trimmings
tragedies
skulking
flint
flopping
relaxing
offload
suites
lists
animized
multilayer
standardizes
Judas
vacuuming
dentally
humanness
inch
Weissmuller
irresponsibly
luckily
culled
medical
bloodbath
subschema
animals
Micronesia
repetitions
Antares
ventilate
pityingly
interdependent
Graves
neonatal
scribbled
chafe
honoring
realtor
elite
funereal
abrogating
sorters
Conley
lectured
Abraham
Hawaii
cage
hushes
Simla
reporters
Dutchman
descendants
groupings
dissociate
coexist
Beebe
Taoism
Connally
fetched
checkpoints
rusting
galling
obliterates
traitor
resumes
analyzable
terminator
gritty
firearm
minima
Selfridge
disable
witchcraft
betroth
Manhattanize
imprint
peeked
swelling
interrelationships
riser
Gandhian
peacock
bee
kanji
dental
scarf
chasm
insolence
syndicate
alike
imperial
convulsion
railway
validate
normalizes
comprehensive
chewing
denizen
schemer
chronicle
Kline
Anatole
partridges
brunch
recruited
dimensions
Chicana
announced
praised
employing
linear
quagmire
western
relishing
serving
scheduling
lore
eventful
arteriole
disentangle
cured
Fenton
avoidable
drains
detectably
husky
impelling
undoes
evened
squeezes
destroyer
rudeness
beaner
boorish
Everhart
encompass
mushrooms
Alison
externally
pellagra
cult
creek
Huffman
Majorca
governing
gadfly
reassigned
intentness
craziness
psychic
squabbled
burlesque
capped
extracted
DiMaggio
exclamation
subdirectory
fangs
buyer
pithing
transistorizing
nonbiodegradable
dislocate
monochromatic
batting
postcondition
catalog
Remus
devices
bike
qualify
detained
commended
civilize
Elmhurst
anesthetizing
deaf
Brigham
title
coarse
combinations
grayness
innumerable
Caroline
fatty
eastbound
inexperienced
hoarder
scotch
passport
strategic
gated
flog
Pipestone
Dar
Corcoran
flyers
competitions
suppliers
skips
institutes
troop
connective
denies
polka
observations
askers
homeless
Anna
subdirectories
decaying
outwitting
Harpy
crazed
suffocate
provers
technically
Franklinizations
considered
tinnily
uninterruptedly
whistled
automate
gutting
surreptitious
Choctaw
cooks
millivolt
counterpoise
Gothicism
feminine
metaphysically
sanding
contributorily
receivers
adjourn
straggled
druggists
thanking
ostrich
hopelessness
Eurydice
excitation
presumes
imaginable
concoct
peering
Phelps
ferociousness
sentences
unlocks
engrossing
Ruth
tying
exclaimers
synergy
Huey
merging
judges
Shylock
Miltonism
hen
honeybee
towers
dilutes
numerals
democracy
Ibero-
invalids
behavior
accruing
relics
rackets
Fischbein
phony
cross
cleanup
conspirator
label
university
cleansed
ballgown
starlet
aqueous
portrayal
despising
distort
palmed
faced
silverware
assessor
spiders
artificially
reminiscence
Mexican
obnoxious
fragile
apprehensible
births
garages
panty
anteater
displacement
drovers
patenting
far
shrieks
aligning
pragmatism
fevers
reexamines
occupancies
sweats
modulators
demand
Madeira
Viennese
chillier
wildcats
gentle
Angles
accuracies
toggle
Mendelssohn
behaviorally
Rochford
mirror
Modula
clobbering
chronography
Eskimoizeds
British
pitfalls
verify
scatter
Aztecan
acuity
sinking
beasts
Witt
physicists
folksong
strokes
crowder
merry
cadenced
alimony
principled
golfing
undiscovered
irritates
patriots
rooms
towering
displease
photosensitive
inking
gainers
leaning
hydrant
preserve
blinded
interactions
Barry
whiteness
pastimes
Edenization
Muscat
assassinated
labeled
glacial
implied
bibliographies
Buchanan
forgivably
innuendo
den
submarines
mouthful
expiring
unfulfilled
precession
nullified
affects
Cynthia
Chablis
betterments
advertising
rubies
southwest
superstitious
tabernacle
silk
handsomest
Persian
analog
complex
Taoist
suspend
relegated
awesome
Bruxelles
imprecisely
televise
braking
true
disappointing
navally
circus
beetles
trumps
fourscore
Blackfoots
Grady
quiets
floundered
profundity
Garrisonian
Strauss
cemented
contrition
mutations
exhibits
tits
mate
arches
Moll
ropers
bombast
difficultly
adsorption
definiteness
cultivation
heals
Heusen
target
cited
congresswoman
Katherine
titter
aspire
Mardis
Nadia
estimating
stuck
fifteenth
Colombo
survey
staffing
obtain
loaded
slaughtered
lights
circumference
dull
weekly
wetness
visualized
Tannenbaum
moribund
demultiplex
lockings
thugs
unnerves
abut
Chippewa
stratifications
signaled
Italianizes
algorithmic
paranoid
camping
signifying
Patrice
search
Angeles
semblance
taxed
Beatrice
retrace
lockout
grammatic
helmsman
uniform
hamming
disobedience
captivated
transferals
cartographer
aims
Pakistani
burglarized
saucepans
lacerating
corny
megabytes
chancellor
bulk
commits
meson
deputies
northeaster
dipole
machining
therefore
Telefunken
salvaging
Corinthianizes
restlessly
bromides
generalized
mishaps
quelling
spiritual
beguiles
Trobriand
fleeing
Armour
chin
provers
aeronautic
voltage
sash
anaerobic
simultaneous
accumulating
Medusan
shouted
freakish
index
commercially
mistiness
endpoint
straight
flurried
denotative
coming
commencements
gentleman
gifted
Shanghais
sportswriting
sloping
navies
leaflet
shooter
Joplin
babies
subdivision
burstiness
belted
assails
admiring
swaying
Goldstine
fitting
Norwalk
weakening
analogy
deludes
cokes
Clayton
exhausts
causality
sating
icon
throttles
communicants
dehydrate
priceless
publicly
incidentals
commonplace
mumbles
furthermore
cautioned
parametrized
registration
sadly
positioning
babysitting
eternal
hoarder
congregates
rains
workers
sags
unplug
garage
boulder
hollowly
specifics
Teresa
Winsett
convenient
buckboards
amenities
resplendent
priding
configurations
untidiness
Brice
sews
participated
Simon
certificates
Fitzpatrick
Evanston
misted
textures
save
count
rightful
chaperone
Lizzy
clenched
effortlessly
accessed
beaters
Hornblower
vests
indulgences
infallibly
unwilling
excrete
spools
crunches
overestimating
ineffective
humiliation
sophomore
star
rifles
dialysis
arriving
indulge
clockers
languages
Antarctica
percentage
ceiling
specification
regimented
ciphers
pictures
serpents
allot
realized
mayoral
opaquely
hostess
fiftieth
incorrectly
decomposition
stranglings
mixture
electroencephalography
similarities
charges
freest
Greenberg
tinting
expelled
warm
smoothed
deductions
Romano
bitterroot
corset
securing
environing
cute
Crays
heiress
inform
avenge
universals
Kinsey
ravines
bestseller
equilibrium
extents
relatively
pressure
critiques
befouled
rightfully
mechanizing
Latinizes
timesharing
Aden
embassies
males
shapelessly
genres
mastering
Newtonian
finishers
abates
teem
kiting
stodgy
scalps
feed
guitars
airships
store
denounces
Pyle
Saxony
serializations
Peruvian
taxonomically
kingdom
stint
Sault
faithful
Ganymede
tidiness
gainful
contrary
Tipperary
tropics
theorizers
renew
already
terminal
Hegelian
hypothesizer
warningly
journalizing
nested
Lars
saplings
foothill
labeled
imperiously
reporters
furnishings
precipitable
discounts
excises
Stalin
despot
ripeness
Arabia
unruly
mournfulness
boom
slaughter
Sabine
handy
rural
organizer
shipyard
civics
inaccuracy
rules
juveniles
comprised
investigations
stabilizes
seminaries
Hunter
sporty
test
weasels
CERN
tempering
afore
Galatean
techniques
error
veranda
severely
Cassites
forthcoming
guides
vanish
lied
sawtooth
fated
gradually
widens
preclude
Jobrel
hooker
rainstorm
disconnects
cruelty
exponentials
affective
arteries
Crosby
acquaint
evenhandedly
percentage
disobedience
humility
gleaning
petted
bloater
minion
marginal
apiary
measures
precaution
repelled
primary
coverings
Artemia
navigate
spatial
Gurkha
meanwhile
Melinda
Butterfield
Aldrich
previewing
glut
unaffected
inmate
mineral
impending
meditation
ideas
miniaturizes
lewdly
title
youthfulness
creak
Chippewa
clamored
freezes
forgivably
reduce
McGovern
Nazis
epistle
socializes
conceptions
Kevin
uncovering
chews
appendixes
appendixes
appendixes
appendixes
appendixes
appendixes
raining
infest
compartment
minting
ducks
roped
waltz
Lillian
repressions
chillingly
noncritical
lithograph
spongers
parenthood
posed
instruments
filial
fixedly
relives
Pandora
watering
ungrateful
secures
chastisers
icon
reuniting
imagining
abiding
omnisciently
Britannic
scholastics
mechanics
humidly
masterpiece
however
Mendelian
jarred
scolds
infatuate
willed
joyfully
Microsoft
fibrosities
Baltimorean
equestrian
Goodrich
apish
Adlerian
Tropez
nouns
distracting
mutton
bridgeable
stickers
transcontinental
amateurish
Gandhian
stratified
chamberlains
creditably
philosophic
ores
Carleton
tape
afloat
goodness
welcoming
Pinsky
halting
bibliography
decoding
variance
allowed
dire
dub
poisoning
Iraqis
heaving
population
bomb
Majorca
Gershwins
explorers
libretto
occurred
Lagos
rats
bankruptcies
crying
unexpected
accessed
colorful
versatility
cosy
Darius
mastering
Asiaticizations
offerers
uncles
sleepwalk
Ernestine
checksumming
stopped
sicker
Italianization
alphabetic
pharmaceutic
creator
chess
charcoal
Epiphany
bulldozes
Pygmalion
caressing
Palestine
regimented
scars
realest
diffusing
clubroom
Blythe
ahead
reviver
retransmitting
landslide
Eiffel
absentee
aye
forked
Peruvianizes
clerked
tutor
boulevard
shuttered
quotes
Caltech
Mossberg
kept
roundly
features
imaginable
controller
racial
uprisings
narrowed
cannot
vest
famine
sugars
exterminated
belays
Hodges
translatable
duality
recording
rouses
poison
attitude
dusted
encompasses
presentation
Kantian
imprecision
saving
maternal
hewed
kerosene
Cubans
photographers
nymph
bedlam
north
Schoenberg
botany
curs
solidification
inheritresses
stiller
t1
suite
ransomer
Willy
Rena
Seattle
relaxes
exclaim
exclaim
implicated
distinguish
assayed
homeowner
and
stealth
coinciding
founder
environing
jewelry
lemons
brokenness
bedpost
assurers
annoyers
affixed
warbling
seriously
boasted
Chantilly
Iranizes
violinist
extramarital
spates
cloakroom
gazer
hand
tucked
gems
clinker
refiner
callus
leopards
comfortingly
generically
getters
sexually
spear
serums
Italianization
attendants
spies
Anthony
planar
cupped
cleanser
commuters
honeysuckle
orphanage
skies
crushers
Puritan
squeezer
bruises
bonfire
Colombo
nondecreasing
DELETE FROM t2 WHERE fld3="d%" ORDER BY RAND();
SELECT fld3 FROM t2;
fld3
Omaha
breaking
Romans
intercepted
bewilderingly
astound
admonishing
sumac
flanking
combed
subjective
scatterbrain
Eulerian
dubbed
Kane
overlay
perturb
goblins
annihilates
Wotan
snatching
concludes
laterally
yelped
grazing
Baird
celery
misunderstander
handgun
foldout
mystic
succumbed
Nabisco
fingerings
aging
afield
ammonium
boat
intelligibility
Augustine
teethe
dreaded
scholastics
audiology
wallet
parters
eschew
quitter
neat
Steinberg
jarring
tinily
balled
persist
attainments
fanatic
measures
rightfulness
capably
impulsive
starlet
terminators
untying
announces
featherweight
pessimist
daughter
decliner
lawgiver
stated
readable
attrition
cascade
motors
interrogate
pests
stairway
dopers
testicle
Parsifal
leavings
postulation
squeaking
contrasted
leftover
whiteners
erases
Punjab
Merritt
Quixotism
sweetish
dogging
scornfully
bellow
bills
cupboard
sureties
puddings
tapestry
fetters
bivalves
incurring
Adolph
pithed
emergency
Miles
trimmings
tragedies
skulking
flint
flopping
relaxing
offload
suites
lists
animized
multilayer
standardizes
Judas
vacuuming
dentally
humanness
inch
Weissmuller
irresponsibly
luckily
culled
medical
bloodbath
subschema
animals
Micronesia
repetitions
Antares
ventilate
pityingly
interdependent
Graves
neonatal
scribbled
chafe
honoring
realtor
elite
funereal
abrogating
sorters
Conley
lectured
Abraham
Hawaii
cage
hushes
Simla
reporters
Dutchman
descendants
groupings
dissociate
coexist
Beebe
Taoism
Connally
fetched
checkpoints
rusting
galling
obliterates
traitor
resumes
analyzable
terminator
gritty
firearm
minima
Selfridge
disable
witchcraft
betroth
Manhattanize
imprint
peeked
swelling
interrelationships
riser
Gandhian
peacock
bee
kanji
dental
scarf
chasm
insolence
syndicate
alike
imperial
convulsion
railway
validate
normalizes
comprehensive
chewing
denizen
schemer
chronicle
Kline
Anatole
partridges
brunch
recruited
dimensions
Chicana
announced
praised
employing
linear
quagmire
western
relishing
serving
scheduling
lore
eventful
arteriole
disentangle
cured
Fenton
avoidable
drains
detectably
husky
impelling
undoes
evened
squeezes
destroyer
rudeness
beaner
boorish
Everhart
encompass
mushrooms
Alison
externally
pellagra
cult
creek
Huffman
Majorca
governing
gadfly
reassigned
intentness
craziness
psychic
squabbled
burlesque
capped
extracted
DiMaggio
exclamation
subdirectory
fangs
buyer
pithing
transistorizing
nonbiodegradable
dislocate
monochromatic
batting
postcondition
catalog
Remus
devices
bike
qualify
detained
commended
civilize
Elmhurst
anesthetizing
deaf
Brigham
title
coarse
combinations
grayness
innumerable
Caroline
fatty
eastbound
inexperienced
hoarder
scotch
passport
strategic
gated
flog
Pipestone
Dar
Corcoran
flyers
competitions
suppliers
skips
institutes
troop
connective
denies
polka
observations
askers
homeless
Anna
subdirectories
decaying
outwitting
Harpy
crazed
suffocate
provers
technically
Franklinizations
considered
tinnily
uninterruptedly
whistled
automate
gutting
surreptitious
Choctaw
cooks
millivolt
counterpoise
Gothicism
feminine
metaphysically
sanding
contributorily
receivers
adjourn
straggled
druggists
thanking
ostrich
hopelessness
Eurydice
excitation
presumes
imaginable
concoct
peering
Phelps
ferociousness
sentences
unlocks
engrossing
Ruth
tying
exclaimers
synergy
Huey
merging
judges
Shylock
Miltonism
hen
honeybee
towers
dilutes
numerals
democracy
Ibero-
invalids
behavior
accruing
relics
rackets
Fischbein
phony
cross
cleanup
conspirator
label
university
cleansed
ballgown
starlet
aqueous
portrayal
despising
distort
palmed
faced
silverware
assessor
spiders
artificially
reminiscence
Mexican
obnoxious
fragile
apprehensible
births
garages
panty
anteater
displacement
drovers
patenting
far
shrieks
aligning
pragmatism
fevers
reexamines
occupancies
sweats
modulators
demand
Madeira
Viennese
chillier
wildcats
gentle
Angles
accuracies
toggle
Mendelssohn
behaviorally
Rochford
mirror
Modula
clobbering
chronography
Eskimoizeds
British
pitfalls
verify
scatter
Aztecan
acuity
sinking
beasts
Witt
physicists
folksong
strokes
crowder
merry
cadenced
alimony
principled
golfing
undiscovered
irritates
patriots
rooms
towering
displease
photosensitive
inking
gainers
leaning
hydrant
preserve
blinded
interactions
Barry
whiteness
pastimes
Edenization
Muscat
assassinated
labeled
glacial
implied
bibliographies
Buchanan
forgivably
innuendo
den
submarines
mouthful
expiring
unfulfilled
precession
nullified
affects
Cynthia
Chablis
betterments
advertising
rubies
southwest
superstitious
tabernacle
silk
handsomest
Persian
analog
complex
Taoist
suspend
relegated
awesome
Bruxelles
imprecisely
televise
braking
true
disappointing
navally
circus
beetles
trumps
fourscore
Blackfoots
Grady
quiets
floundered
profundity
Garrisonian
Strauss
cemented
contrition
mutations
exhibits
tits
mate
arches
Moll
ropers
bombast
difficultly
adsorption
definiteness
cultivation
heals
Heusen
target
cited
congresswoman
Katherine
titter
aspire
Mardis
Nadia
estimating
stuck
fifteenth
Colombo
survey
staffing
obtain
loaded
slaughtered
lights
circumference
dull
weekly
wetness
visualized
Tannenbaum
moribund
demultiplex
lockings
thugs
unnerves
abut
Chippewa
stratifications
signaled
Italianizes
algorithmic
paranoid
camping
signifying
Patrice
search
Angeles
semblance
taxed
Beatrice
retrace
lockout
grammatic
helmsman
uniform
hamming
disobedience
captivated
transferals
cartographer
aims
Pakistani
burglarized
saucepans
lacerating
corny
megabytes
chancellor
bulk
commits
meson
deputies
northeaster
dipole
machining
therefore
Telefunken
salvaging
Corinthianizes
restlessly
bromides
generalized
mishaps
quelling
spiritual
beguiles
Trobriand
fleeing
Armour
chin
provers
aeronautic
voltage
sash
anaerobic
simultaneous
accumulating
Medusan
shouted
freakish
index
commercially
mistiness
endpoint
straight
flurried
denotative
coming
commencements
gentleman
gifted
Shanghais
sportswriting
sloping
navies
leaflet
shooter
Joplin
babies
subdivision
burstiness
belted
assails
admiring
swaying
Goldstine
fitting
Norwalk
weakening
analogy
deludes
cokes
Clayton
exhausts
causality
sating
icon
throttles
communicants
dehydrate
priceless
publicly
incidentals
commonplace
mumbles
furthermore
cautioned
parametrized
registration
sadly
positioning
babysitting
eternal
hoarder
congregates
rains
workers
sags
unplug
garage
boulder
hollowly
specifics
Teresa
Winsett
convenient
buckboards
amenities
resplendent
priding
configurations
untidiness
Brice
sews
participated
Simon
certificates
Fitzpatrick
Evanston
misted
textures
save
count
rightful
chaperone
Lizzy
clenched
effortlessly
accessed
beaters
Hornblower
vests
indulgences
infallibly
unwilling
excrete
spools
crunches
overestimating
ineffective
humiliation
sophomore
star
rifles
dialysis
arriving
indulge
clockers
languages
Antarctica
percentage
ceiling
specification
regimented
ciphers
pictures
serpents
allot
realized
mayoral
opaquely
hostess
fiftieth
incorrectly
decomposition
stranglings
mixture
electroencephalography
similarities
charges
freest
Greenberg
tinting
expelled
warm
smoothed
deductions
Romano
bitterroot
corset
securing
environing
cute
Crays
heiress
inform
avenge
universals
Kinsey
ravines
bestseller
equilibrium
extents
relatively
pressure
critiques
befouled
rightfully
mechanizing
Latinizes
timesharing
Aden
embassies
males
shapelessly
genres
mastering
Newtonian
finishers
abates
teem
kiting
stodgy
scalps
feed
guitars
airships
store
denounces
Pyle
Saxony
serializations
Peruvian
taxonomically
kingdom
stint
Sault
faithful
Ganymede
tidiness
gainful
contrary
Tipperary
tropics
theorizers
renew
already
terminal
Hegelian
hypothesizer
warningly
journalizing
nested
Lars
saplings
foothill
labeled
imperiously
reporters
furnishings
precipitable
discounts
excises
Stalin
despot
ripeness
Arabia
unruly
mournfulness
boom
slaughter
Sabine
handy
rural
organizer
shipyard
civics
inaccuracy
rules
juveniles
comprised
investigations
stabilizes
seminaries
Hunter
sporty
test
weasels
CERN
tempering
afore
Galatean
techniques
error
veranda
severely
Cassites
forthcoming
guides
vanish
lied
sawtooth
fated
gradually
widens
preclude
Jobrel
hooker
rainstorm
disconnects
cruelty
exponentials
affective
arteries
Crosby
acquaint
evenhandedly
percentage
disobedience
humility
gleaning
petted
bloater
minion
marginal
apiary
measures
precaution
repelled
primary
coverings
Artemia
navigate
spatial
Gurkha
meanwhile
Melinda
Butterfield
Aldrich
previewing
glut
unaffected
inmate
mineral
impending
meditation
ideas
miniaturizes
lewdly
title
youthfulness
creak
Chippewa
clamored
freezes
forgivably
reduce
McGovern
Nazis
epistle
socializes
conceptions
Kevin
uncovering
chews
appendixes
appendixes
appendixes
appendixes
appendixes
appendixes
raining
infest
compartment
minting
ducks
roped
waltz
Lillian
repressions
chillingly
noncritical
lithograph
spongers
parenthood
posed
instruments
filial
fixedly
relives
Pandora
watering
ungrateful
secures
chastisers
icon
reuniting
imagining
abiding
omnisciently
Britannic
scholastics
mechanics
humidly
masterpiece
however
Mendelian
jarred
scolds
infatuate
willed
joyfully
Microsoft
fibrosities
Baltimorean
equestrian
Goodrich
apish
Adlerian
Tropez
nouns
distracting
mutton
bridgeable
stickers
transcontinental
amateurish
Gandhian
stratified
chamberlains
creditably
philosophic
ores
Carleton
tape
afloat
goodness
welcoming
Pinsky
halting
bibliography
decoding
variance
allowed
dire
dub
poisoning
Iraqis
heaving
population
bomb
Majorca
Gershwins
explorers
libretto
occurred
Lagos
rats
bankruptcies
crying
unexpected
accessed
colorful
versatility
cosy
Darius
mastering
Asiaticizations
offerers
uncles
sleepwalk
Ernestine
checksumming
stopped
sicker
Italianization
alphabetic
pharmaceutic
creator
chess
charcoal
Epiphany
bulldozes
Pygmalion
caressing
Palestine
regimented
scars
realest
diffusing
clubroom
Blythe
ahead
reviver
retransmitting
landslide
Eiffel
absentee
aye
forked
Peruvianizes
clerked
tutor
boulevard
shuttered
quotes
Caltech
Mossberg
kept
roundly
features
imaginable
controller
racial
uprisings
narrowed
cannot
vest
famine
sugars
exterminated
belays
Hodges
translatable
duality
recording
rouses
poison
attitude
dusted
encompasses
presentation
Kantian
imprecision
saving
maternal
hewed
kerosene
Cubans
photographers
nymph
bedlam
north
Schoenberg
botany
curs
solidification
inheritresses
stiller
t1
suite
ransomer
Willy
Rena
Seattle
relaxes
exclaim
exclaim
implicated
distinguish
assayed
homeowner
and
stealth
coinciding
founder
environing
jewelry
lemons
brokenness
bedpost
assurers
annoyers
affixed
warbling
seriously
boasted
Chantilly
Iranizes
violinist
extramarital
spates
cloakroom
gazer
hand
tucked
gems
clinker
refiner
callus
leopards
comfortingly
generically
getters
sexually
spear
serums
Italianization
attendants
spies
Anthony
planar
cupped
cleanser
commuters
honeysuckle
orphanage
skies
crushers
Puritan
squeezer
bruises
bonfire
Colombo
nondecreasing
DROP TABLE t1;
ALTER TABLE t2 RENAME t1
#;
DROP TABLE t1;
CREATE TABLE t1 (
Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL
) ENGINE = CSV;
INSERT INTO t1 VALUES (9410,9412);
select period from t1;
period
9410
drop table if exists t1,t2,t3,t4;
Warnings:
Note	1051	Unknown table 't2'
Note	1051	Unknown table 't3'
Note	1051	Unknown table 't4'
DROP TABLE IF EXISTS bug13894;
CREATE TABLE bug13894 ( val integer ) ENGINE = CSV;
INSERT INTO bug13894 VALUES (5);
INSERT INTO bug13894 VALUES (10);
INSERT INTO bug13894 VALUES (11);
INSERT INTO bug13894 VALUES (10);
SELECT * FROM bug13894;
val
5
10
11
10
UPDATE  bug13894 SET val=6 WHERE val=10;
SELECT * FROM bug13894;
val
5
11
6
6
DROP TABLE bug13894;
DROP TABLE IF EXISTS bug14672;
CREATE TABLE bug14672 (c1 integer) engine = CSV;
INSERT INTO bug14672 VALUES (1), (2), (3);
SELECT * FROM bug14672;
c1
1
2
3
DELETE FROM bug14672 WHERE c1 = 2;
SELECT * FROM bug14672;
c1
1
3
INSERT INTO bug14672 VALUES (4);
SELECT * FROM bug14672;
c1
1
3
4
INSERT INTO bug14672 VALUES (5);
SELECT * FROM bug14672;
c1
1
3
4
5
DROP TABLE bug14672;
CREATE TABLE test_concurrent_insert ( val integer ) ENGINE = CSV;
LOCK TABLES test_concurrent_insert READ LOCAL;
INSERT INTO test_concurrent_insert VALUES (1);
SELECT * FROM test_concurrent_insert;
val
1
SELECT * FROM test_concurrent_insert;
val
UNLOCK TABLES;
LOCK TABLES test_concurrent_insert WRITE;
INSERT INTO test_concurrent_insert VALUES (2);
SELECT * FROM test_concurrent_insert;
val
1
2
UNLOCK TABLES;
DROP TABLE test_concurrent_insert;
CREATE TABLE test_repair_table ( val integer ) ENGINE = CSV;
CHECK TABLE test_repair_table;
Table	Op	Msg_type	Msg_text
test.test_repair_table	check	status	OK
REPAIR TABLE test_repair_table;
Table	Op	Msg_type	Msg_text
test.test_repair_table	repair	status	OK
DROP TABLE test_repair_table;
CREATE TABLE test_repair_table2 ( val integer ) ENGINE = CSV;
SELECT * from test_repair_table2;
val
Warnings:
Error	1194	Table 'test_repair_table2' is marked as crashed and should be repaired
SELECT * from test_repair_table2;
val
test_repair_table2.CSM
CHECK TABLE test_repair_table2;
Table	Op	Msg_type	Msg_text
test.test_repair_table2	check	status	OK
DROP TABLE test_repair_table2;
CREATE TABLE test_repair_table3 ( val integer ) ENGINE = CSV;
CHECK TABLE test_repair_table3;
Table	Op	Msg_type	Msg_text
test.test_repair_table3	check	error	Corrupt
REPAIR TABLE test_repair_table3;
Table	Op	Msg_type	Msg_text
test.test_repair_table3	repair	status	OK
SELECT * FROM test_repair_table3;
val
1
4
DROP TABLE test_repair_table3;
CREATE TABLE test_repair_table4 (
num int not null,
magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL,
company_name char(30) DEFAULT '' NOT NULL,
founded char(4) DEFAULT '' NOT NULL
) ENGINE = CSV;
SELECT * FROM test_repair_table4;
num	magic_no	company_name	founded
Warnings:
Error	1194	Table 'test_repair_table4' is marked as crashed and should be repaired
SELECT * FROM test_repair_table4;
num	magic_no	company_name	founded
CHECK TABLE test_repair_table4;
Table	Op	Msg_type	Msg_text
test.test_repair_table4	check	status	OK
INSERT INTO test_repair_table4 VALUES (2,101,'SAP','1972');
INSERT INTO test_repair_table4 VALUES (1,101,'Microsoft','1978');
INSERT INTO test_repair_table4 VALUES (2,101,'MySQL','1995');
SELECT * FROM test_repair_table4;
num	magic_no	company_name	founded
2	0101	SAP	1972
1	0101	Microsoft	1978
2	0101	MySQL	1995
CHECK TABLE test_repair_table4;
Table	Op	Msg_type	Msg_text
test.test_repair_table4	check	status	OK
REPAIR TABLE test_repair_table4;
Table	Op	Msg_type	Msg_text
test.test_repair_table4	repair	status	OK
SELECT * FROM test_repair_table4;
num	magic_no	company_name	founded
2	0101	SAP	1972
1	0101	Microsoft	1978
2	0101	MySQL	1995
CHECK TABLE test_repair_table4;
Table	Op	Msg_type	Msg_text
test.test_repair_table4	check	status	OK
REPAIR TABLE test_repair_table4;
Table	Op	Msg_type	Msg_text
test.test_repair_table4	repair	status	OK
SELECT * FROM test_repair_table4;
num	magic_no	company_name	founded
2	0101	SAP	1972
1	0101	Microsoft	1978
2	0101	MySQL	1995
DROP TABLE test_repair_table4;
CREATE TABLE test_repair_table5 (
num int not null,
magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL,
company_name char(30) DEFAULT '' NOT NULL,
founded char(4) DEFAULT '' NOT NULL
) ENGINE = CSV;
CHECK TABLE test_repair_table5;
Table	Op	Msg_type	Msg_text
test.test_repair_table5	check	error	Corrupt
REPAIR TABLE test_repair_table5;
Table	Op	Msg_type	Msg_text
test.test_repair_table5	repair	status	OK
SELECT * FROM test_repair_table5;
num	magic_no	company_name	founded
INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT", 1876);
SELECT * FROM test_repair_table5;
num	magic_no	company_name	founded
1	0102	CORRECT	1876
FLUSH TABLES;
CHECK TABLE test_repair_table5;
Table	Op	Msg_type	Msg_text
test.test_repair_table5	check	error	Corrupt
REPAIR TABLE test_repair_table5;
Table	Op	Msg_type	Msg_text
test.test_repair_table5	repair	status	OK
SELECT * FROM test_repair_table5;
num	magic_no	company_name	founded
1	0102	CORRECT	1876
INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT2", 1876);
SELECT * FROM test_repair_table5;
num	magic_no	company_name	founded
1	0102	CORRECT	1876
1	0102	CORRECT2	1876
FLUSH TABLES;
CHECK TABLE test_repair_table5;
Table	Op	Msg_type	Msg_text
test.test_repair_table5	check	error	Corrupt
REPAIR TABLE test_repair_table5;
Table	Op	Msg_type	Msg_text
test.test_repair_table5	repair	status	OK
SELECT * FROM test_repair_table5;
num	magic_no	company_name	founded
1	0102	CORRECT	1876
1	0102	CORRECT2	1876
DROP TABLE test_repair_table5;
create table t1 (a int) engine=csv;
insert t1 values (1);
delete from t1;
affected rows: 1
delete from t1;
affected rows: 0
insert t1 values (1),(2);
delete from t1;
affected rows: 2
insert t1 values (1),(2),(3);
flush tables;
delete from t1;
affected rows: 3
insert t1 values (1),(2),(3),(4);
flush tables;
select count(*) from t1;
count(*)
4
delete from t1;
affected rows: 4
insert t1 values (1),(2),(3),(4),(5);
truncate table t1;
affected rows: 0
drop table t1;
create table t1 (v varchar(32));
insert into t1 values ('def'),('abc'),('hij'),('3r4f');
select * from t1;
v
def
abc
hij
3r4f
alter table t1 change v v2 varchar(32);
select * from t1;
v2
def
abc
hij
3r4f
alter table t1 change v2 v varchar(64);
select * from t1;
v
def
abc
hij
3r4f
update t1 set v = 'lmn' where v = 'hij';
select * from t1;
v
def
abc
lmn
3r4f
alter table t1 add i int auto_increment not null primary key first;
select * from t1;
i	v
1	def
2	abc
3	lmn
4	3r4f
update t1 set i=5 where i=3;
select * from t1;
i	v
1	def
2	abc
5	lmn
4	3r4f
alter table t1 change i i bigint;
select * from t1;
i	v
1	def
2	abc
5	lmn
4	3r4f
alter table t1 add unique key (i, v);
select * from t1 where i between 2 and 4 and v in ('def','3r4f','lmn');
i	v
4	3r4f
drop table t1;