MySQL Projects

to run all projects from this page download the create and insert employee database here Employee Database

Select Statements

Select Statements

Image of Select Statements written in Mysql to pull datafrom a database

Image of the output from one of these select statements from a table called tools

Image of the output from one of these select statments from a table called department

Adding, Updating, and Deleting

Adding, Updating, and Deleting Statements

Image of Mysql statements for adding updating and deleteing data from a database

ouput of a select statement for an item that was just added to a database