Lab 7: Report Writing

Laboratory Report DeVry University College of Engineering and Information Sciences

Course Number: DBM405A

Professor:

Laboratory Number: 6

Laboratory Title: Adding, Changing and Deleting records

Submittal Date: 4/14/2019

Note: There is no limit on how much information you will enter under the three topics below. It is important to be clear and complete with your comments. Like a scientist, you are documenting your progress in this week’s lab experiment.

Objectives: In your own words, what was this lab designed to accomplish? What was its purpose?

This lab will give hands on experience on working with stored procedures and automatically backing up the database.

Results: Discuss the steps you used to complete your lab. Were you successful? What did you learn? What were the results? Explain what you did to accomplish each step. You can include screen shots, code listings, etc. to clearly explain what you did.

Using query

CREATE PROCEDURE setScores() BEGIN update `season` set `AwayTeamScore` = 0, `hometeamscore` = 0; END

Using query

CREATE PROCEDURE

displaySeason()

BEGIN

select*

from 'season';

END

Using query

mysqldump ---user ['usr'] ---password=['pass']

[database 'baseball'] > ['backupFile']

Conclusions: After completing this lab, in your own words, what conclusions can you draw from this experience?

This lab gave hands on experience on working with stored procedures and automatically backing up the database.

Student:
	Name		Program		Signature