Basic MySQL Command-line Operations Project

Abstract:

“Basic MySQL Command line Operations” is an application developed in using MYSQL.This application has the only module which plays a key role which is an admin

Admin can get logged into the application by entering valid credentials.ADmin can add all the details of the employee like employee name, id, salary, email,

address, mobile no.Admin can update and delete all employee details.

In MYSQL command prompt we need to enter MySQL password to get access.Create a database by entering the database name.

After creating the database we can execute the query.We need to create employee table.After creating Employee table all the details of the table can be

inserted into the table.We can update all the details in the employee table by using an update query.: We can delete the details in the employee table by using delete query.

Modules:

admin:

* Admin login with valid username and password

* Admin can add employee details like employee name, id, salary, email, address, mobile no.

* Admin can update and delete all employee details.

Output Screens with Explanation:

Fig: enter mysql password: To Connect Mysql(Database) here user need to enter password, which we enter at the time of installation.

Fig: create Database : Here we need to create database using SQL Query

Fig: execute query: After executing the given query database will be created

Fig: create employee table: Here we will create a table by giving all the required column names using data types and length with a specific table name.

Fig: insert Employee Details: After creating Employee table all the details of the table can be inserted into the table

Fig: Update employee details: We can update all the details in the employee table by using update query.

Fig: Delete Employee Details: We can delete the details in the employee table by using delete query.

 

Related Projects

Leave a Reply

Your email address will not be published. Required fields are marked *