MySql Using Xampp

Using Xampp we can perform all the MySql programs

for using Xampp we have to atfirst download it. After opening it the following control panel pops up we have to start the apache and MySQL programs and after that click on the admit as shown in the image below

After clicking on admit option the following page opens

In this image we have to created a database for MySQL program for that we have to go to the new option then give a name to the database and press the create button

The database 'Teacher' created as shown in the image below

In this step we will create a Table 'student' which will contain the name, roll, age, and email, this table creates under the database Teacher. We write the following command for table creation.

Click on the go button

Table 'student' successfully created

In this step we insert values to the table by taking user input. User will write the command and pass the required values to the table. After writing the command press the go button.

The values in the table inserted successfully

To check the value go to the 'student' table, here we can see all the values that we had pass

In this way we can use all the mysql commands in the xampp