Question: please answer from 5 to 9 questions. they are mysql database coding questions. 4. Based on the information entered info the table, use the command

 please answer from 5 to 9 questions. they are mysql database

please answer from 5 to 9 questions. they are mysql database coding questions.

4. Based on the information entered info the table, use the command below to display and all employee table EMPLOYEE s, Make a change to the table structure and change a column name and the datatype definitinn in the Employee Payroll Database Application table created above. You choose which field you would like to EMPLOYEE 6. Create a query to view (at least 3 fields) one of the employees' formation loaded into the Employee Payroll Database Application table created above. You choose which three fields you would like to retrieve from the table. Base your query on a 7. a query to view the employees' names loaded into the Employee PayToll Database Application table created above and display the names in descending order. Use the commands to combine the first and last name and display as a full name in the query. EMPLOYEE s. save all nformation in the table 9. Write to determine how many records are loaded into the table and change the heading from count a query to number. 4 INSERT CHAR 2, DATE 8- SELECT ABLE 7. VALUES KE AND COUNT 8. ADD FROM ALTER NOT NU 25. AFTER DISTINCT 23. COMM 21, ORDER BY 29 DESC 30, CONCAT 28, COUNT 26 SHOW 27, CHANGE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!