(1) Install MySQL in your computer. You may also install xampp instead of just M
ID: 3871778 • Letter: #
Question
(1) Install MySQL in your computer. You may also install xampp instead of just MySQL. Install the 'Big' PVFC database of the textbook in MySQL and call the database 'bigpvfc'. You may execute the sql file, bigpvfc.sql (provided separately), in MySQL console.
Provide the MySQL commands for the following queries.
(c) List the names and birthdates of employees without missing information in their birthdates.
+------------+----------------+---------------------+
| EmployeeId | EmployeeName | EmployeeBirthDate |
+------------+----------------+---------------------+
| 123-44-345 | Phil Morris | 1957-01-05 00:00:00 |
| 332445667 | Lawrence Haley | 1963-08-15 00:00:00 |
| 454-56-768 | Robert Lewis | 1964-08-25 00:00:00 |
| 555955585 | Mary Smith | 1969-05-06 00:00:00 |
+------------+----------------+---------------------+
4 rows in set (0.00 sec)
Explanation / Answer
As far as I understood the question,
You are referring to the BIGPVFC database and asking the queries about it. It is a sample database which can be imported and have these tables in it
Tablename
Customers
Categories
Employees
OrderDetails
Orders
Products
Shippers
Suppliers
In the Employees table
if you want to select the Name and birthdate
You can type this query
Select EmployeeName, EmployeeBirthDate From Employees;
It will list all the employees with their name and birthdate if you want to list all the information u can type
Select * From Employees
Basic query for Select is Select column name1 column name2, ...... from table name
if you want to add condition you can add it using where clause
the syntax would be Select column name1 column name2, ...... from table name where (condition )
so that u mentioned without missing information so the birthdate should not be null
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.