Relational Database Development 152-156 Structured Query Language (SQL) Single Table Queries Notes Activity Text References Import Employee database in MySQL Pages 97 98, – 100 Pages 98 99 – Pages 100 107 – 110 112 – 128 Pages 117 119 – Pages 112 114 – Pages 107 - 110 Pages Pages Pages 114 117 – 123 128 – Pages Pages 120 123 – Access the MySQL documentation online for more information on MySQL commands and functions: Show all fields from tblEmployees, tblPlants, Basic Query tblTrips Select * From tblName; * represents all fields Selecting Specific Fields for Display Show employee firstname, lastname, plantid, List the fields in the order desired between Select and unionmember From Separate fields with a comma
Relational Database Development 152-156 Structured Query Language (SQL) Single Table Queries Notes Activity Text References Pages 97 – 98, 100 Pages 98 – 99 Pages 100 – 107 110 – 112 128 Pages 117 – 119 Pages 112 – 114 Pages 107 - 110 Pages Pages Pages 114 – 117 123 – 128 Pages Pages 120 – 123 Import Employee database in MySQL Access the MySQL documentation online for more information on MySQL commands and functions: Basic Query Select * From tblName; * represents all fields Show all fields from tblEmployees, tblPlants, tblTrips Selecting Specific Fields for Display List the fields in the order desired between Select and From Separate fields with a comma Show employee firstname, lastname, plantid, unionmember
3%20-%20Single%20Table%20Queries.docx