Database UMIACS数据库UMIACS.pptVIP

4 Creating Fields Enter field name Must be unique, but only within the same table Select field type from a menu Use date/time for times Use text for phone numbers Designate primary key (right mouse button) Save the table That’s when you get to assign a table name Entering Data Open the table Double-click on the icon Enter new data in the bottom row A new (blank) bottom row will appear Close the table No need to “save” – data is stored automatically Building Queries Copy ride.mdb to your C:\ drive “Create Query in Design View” In “Queries” Choose two tables, Flight and Company Pick each field you need using the menus Unclick “show” to not project Enter a criterion to “restrict” Save, exit, and reselect to run the query Fun Facts about Queries Joins are automatic if field names are same Otherwise, drag a line between the fields Sort order is easy to specify Use the menu The SQL SELECT Command Project chooses columns Based on their label Restrict chooses rows Based on their contents e.g. department ID = “HIST” These can be specified together SELECT Student ID, Dept WHERE Dept = “History” Restrict Operators Each SELECT contains a single WHERE Numeric comparison , , =, , … e.g., grade80 Boolean operations e.g., Name = “John” AND Dept “HIST” Structured Query Language DESCRIBE Flight; Structured Query Language SELECT * FROM Flight; Structured Query Language SELECT Company.CompanyName, Company.CompanyPhone, Flight.Origin, Flight.DepartureTime FROM Flight,Company WHERE Flight.CompanyName=Company.CompanyName AND Flight.AvailableSeats3; select address from employee where employee.surname=Smith and employee.forenames=Robert; field table how you want to restrict the rows select dname from employee, departmentwhere employee.depno=department.depno and surname=Smith and forenames=Robert; field tables to join how you want to restrict the rows how to join Create a MySQL Database “root” user creates database + grants permissions Using the WAMP console (or mys