SQLite, Firefox, and our small IMDB movie databasequery results will (hopefully) appear 15 -- Find all films which have "Bill" in the name select * from movie where name like '%Bill%'; More Interesting IMDB queries • Execute the following two queries in a movie -- with "Bill" in the name select fname, lname, role, name from movie, cast, actor where movie.id = "cast".mid and "cast".aid = actor.id and movie.name like '%Bill%'; The table name "cast"0 码力 | 22 页 | 1.83 MB | 1 年前3
Simple Data Storage; SQLiteProfessor, College of Computing Associate Director, MS Analytics Georgia Tech Partly based on materials by Guy Lebanon, Jeffrey Heer, John Stasko, Christos Faloutsos How to store the data? What’s the0 码力 | 17 页 | 687.28 KB | 1 年前3
共 2 条
- 1













