Performing DataBase Operations in XAMPP

XAMPP is a cross-platform web server used to develop and test programs on a local server. It is developed and managed by Apache Friends and is open-source. It has an Apache HTTP Server, MariaDB, and interpreter for 11 different programming languages like Perl and PHP. XAMPP Stands for cross-platform, Apache, MySQL, PHP, and Perl.

• It allows you to build a website on a local web server on your computer.
• Stores data locally

In this article, we are going to perform Database operations like Create, Insert, Update, Delete data from the database created in XAMPP localhost server. We are also going to create a table and then start performing database operations. Following are the list of database operations with their respective syntax:

SELECT statement 

It is used to display all the details from the table.

Syntax: SELECT * FROM 'table_name'

INSERT statement 

It is used to insert data into the table.

Syntax: INSERT INTO `table_name`(`col`, `col2`, `col3`,.. `coln`) VALUES ([value-1],[value-2],
 [value-3],....,[value-n)

Update statement

It is used to change/update any data in the table.

Syntax: UPDATE `table_name` SET `col1`=[value-1],
 `col2`=[value-2],
 `col3`=[value-3],
 `coln`=[value-n] WHERE 1

Delete statement

It is used to delete data from a table.

Syntax: DELETE FROM table_name where col="value"

Procedure:

Follow the below steps to perform database operations on XAMPP:

• Start XAMPP Server
• Create Database and Create Table
• Perform Database Operations
• Verify Resultant Table

Steps to Create a Database:

1. Start XAMPP server

👁 Image

2. Go to Browser and type "http://localhost/phpmyadmin" and Create a database with the name "Vignan" by selecting new

👁 Image
👁 Image

3.  After that, Create table Name "ITDept" and give the number of columns (I created 4 columns) and click on Go

👁 Image

Give column names as "Rollno"(Varchar), "Name"(Varchar), "Gender" (Char), "Address"(Varchar), and Save.

Note: Clicking the "Save" option is important, if not the table is not created.

👁 Image

Then we get the output as:

👁 Image

Performing SQL Operations:

INSERT Operation:

• Click on SQL

👁 Image

• Click on INSERT Option

👁 Image

By default, code is available like this:

INSERT INTO `itdept`(`Rollno`, `Name`, `Gender`, `Address`)
VALUES ([value-1],[value-2],[value-3],[value-4])

• We want to modify the values as follows and click  on "GO"

INSERT INTO `itdept`(`Rollno`, `Name`, `Gender`, `Address`)
 VALUES ("171FA07058","Sravan Kumar Gottumukkala", "m", "HYD" )

👁 Image

Output:

👁 Image

• Now insert 5 records. Data in the database is as follows:

👁 Image

UPDATE Operation:

👁 Image

Default code in the update is:

UPDATE `itdept` SET `Rollno`=[value-1],
`Name`=[value-2],
`Gender`=[value-3],
`Address`=[value-4] WHERE 1

• Now change the name to Sujatha where rollno is 171FA07078 as follows:

UPDATE `itdept` SET NAME="Sujitha" WHERE `Rollno`="171FA07078"

Output:

👁 Image

SELECT Operation:

The Select statement is used to display or query for data from the database. Follow the below steps to do so:

• Click on the Select* option

👁 Image

This will result in the following code generation:

SELECT * FROM `itdept` 

Output:

👁 Image

For Selecting particular data follow the below sample query:

Select Rollno, Name from itept

👁 Image
👁 Image

DELETE Operation:

• Click on the Delete  button to delete the data as shown below:

👁 Image

The generated code would look like below:

DELETE FROM itdept where Rollno="171FA07058"

• Confirm the deletion by clicking YES

👁 Image

Output:

👁 Image

Our Final data in Table is:

👁 Image