43_mysql_database_concept_1

How to open MYSQL?
• We have already installed the XAMPP so we have to just start the services in that and your MySql will work well into your system.
• Now to work on the MySql, open the browser and write http://localhost/phpmyadmin/, then the browser will show the below screen.
• So from here you can create your own database for your application.
• In the below screenshot I have created one database named Harshida_PHP and then click on the create button.

How to create the table in MYSQL DATABASE?
• So when the user click on the create button the below screen will shown to you, from here you can create the database table.
• Here I have created the table named “Harshida_Php_Table1”, which contain the 4 rows into this table.

• Click on the GO button.
How to create the table structure in MYSQL DATABASE?
• After specify the name of the table now it times to create the table structure, give the name to particular column with the data type like integer, varchar etc.
• Using mysql you can assign the auto increment functionality, allow null or not the length of the column and so many operation you can perform using mysql, we can discuss much more about mysql in latter.
• Now in the below screenshot I have specify the 4 column name with datatype and size of that particular column.

• Click on the Save button.

• When user click on the save button the above screen will display which shows that your table is created successfully.
Insert the data in Table using MYSQL
• Now after creating the table if you’re interested to store the default value into that particular table click on to the insert tab.
• From here you store the value into database table.

• Click on the Go Button for insert the data in table.
• When user click on the GO button, the data will inserted, so the below screenshot shows how the value will store using the structure tab.

• If you are interested to check that how many record are there into particular database table just click on the browse tab and you are able to see how many record are present.