In this session we will study MySQL database operations like create, update, select, insert, delete using xampp server .
- So follow the steps given below :
-
- First of all install the Xampp server in your machine.
-
- Goto the xampp folder and open the xampp-control.exe file from it .
-
- Now start the Apache , MySQL and FileZilla module as shown below :
-
- Now open up the browser and enter the following url http://localhost/xampp/ , you will be navigated to the next window .
-
- Then click on phpMyadmin .
-
- The phpadmin window will be displayed:
-
- Click on the Databases tab present at the left hand side as shown below:
-
- The next window will be displayed .
-
- Now here you can enter the name of your database and click on Create button it will create your database which will get added to the recent databases list.
-
- Now click on the mydatabase (i.e The name of your database).
-
- After clicking on mydatabase the next window will get displayed.
-
- Name your table and the mention number of column you want to add and click on Go button.Enter the fields and save it.
-
- After clicking on the save button your table structure is created .
-
- Now if you want to insert the record in your table, click on the insert tab as shown .
-
- After clicking on the insert tab the next window will get displayed where you can insert the record into your table .
-
- After inserting the record click on Browse to see the table contents
-
- To trigger the queries in MySql database , click on the database name present at the left hand side as shown in the figure .
-
- Click on the SQL tab and you will get the following dialog box:-
-
- Here you can fire the sql queries:-
For example : Use of update command to update the record in the table.UPDATE mydemo SET surname_name='maharaja' where id=2;
- Here you can fire the sql queries:-
This will change the second record which has id=2 .
-
- Now click on the Browse tab , this will show us the updated table structure.-
-
- Similarly you can use the insert,select and delete command to perform respective operations on your table.
-
- For demonstrating a select command again select the SQL tab and write the query in it
SELECT first_name FROM mydemo LIMIT 0 , 3
-
- Similarly you can perform various operations on your database .
- Thus we have successfully performed basic operations of MySql on xampp server .
i follow the Learn basic operations of MySQL on Xampp Server and i understand how to use that’s great but your image is not look good, so update it.
thank you…