−

==Movies from Text File to Tables==

==[[user:mpetredi|'''Mitchell Petredis''']]==

===Assignment Reference===

[[Week 6]]

===Movies from Text File to Tables===

#select * from movie where year < 1915

#*4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"

#*9103;1914;"Tillie's Punctured Romance"

#*10898;1914;"Cabiria"

−

#select * from movie where year > 1979 and year < 1990 and title ~ '[0123456789][0123456789][0123456789][0123456789]'

−

#*217;1988;"Cherry 2000"

#*1163;1984;"2010: The Year We Make Contact"

#*1399;1984;"1984"

#*1480;1988;"Cold Summer of 1953"

#*4882;1985;"Butthole Surfers: Blind Eye See All: Live 1985"

#*5482;1989;"Gundam 0080: War in the Pocket"

#*5890;1985;"Transylvania 6-5000"

#*7725;1984;"Hong Kong 1941"

#*15128;1988;"1969"

#*15269;1989;"Mystery Science Theater 3000: The Crawling Hand"

#*15390;1987;"Eric Clapton & Friends: Live 1986"

#*16985;1982;"The 2000 Year Old Man"

#*17007;1987;"Teenage Mutant Ninja Turtles (1980s)"

# select * from movie where title ~ ''''

#*1280 Total Results

#**4;1994;"Paula Abdul's Get Up & Dance"

#**9;1991;"Class of Nuke 'Em High 2"

#**19;2000;"By Dawn's Early Light"

#**23;2001;"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"

#**27;1962;"Sesame Street: Elmo's World: The Street We Live On"

#**30;2003;"Something's Gotta Give"

#**32;2004;"ABC Primetime: Mel Gibson's The Passion of the Christ"

#**34;2003;"Ashtanga Yoga: Beginner's Practice with Nicki Doane"

#**37;1973;"Zatoichi's Conspiracy"

#**54;1952;"We're Not Married"

#select count(*) from movie where title ~ '^Star '

#*61

Unexpected non-MediaWiki exception encountered, of type "Error"
Error: Call to undefined function each() in /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php:374
Stack trace:
#0 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(480): _DiffEngine->_diag()
#1 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(291): _DiffEngine->_compareseq()
#2 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(175): _DiffEngine->diff_local()
#3 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(653): _DiffEngine->diff()
#4 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(820): Diff->__construct()
#5 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(1240): MappedDiff->__construct()
#6 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(1458): WordLevelDiff->__construct()
#7 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(952): TableDiffFormatter->_changed()
#8 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(924): DiffFormatter->_block()
#9 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(765): DiffFormatter->format()
#10 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(655): DifferenceEngine->generateDiffBody()
#11 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(593): DifferenceEngine->getDiffBody()
#12 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(566): DifferenceEngine->getDiff()
#13 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(409): DifferenceEngine->showDiff()
#14 /apps/xmlpipedb/biodb/fall2013/includes/Article.php(725): DifferenceEngine->showDiffPage()
#15 /apps/xmlpipedb/biodb/fall2013/includes/Article.php(478): Article->showDiffPage()
#16 /apps/xmlpipedb/biodb/fall2013/includes/actions/ViewAction.php(37): Article->view()
#17 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(427): ViewAction->show()
#18 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(304): MediaWiki->performAction()
#19 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(536): MediaWiki->performRequest()
#20 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(446): MediaWiki->main()
#21 /apps/xmlpipedb/biodb/fall2013/index.php(59): MediaWiki->run()
#22 {main}