View full version

DATABASE SQL

Database:
Database is a group of facts in a method that provisions to easy access. As well as structure management and updating.
A Database is divided into tables that store applicable for details.

There are the examples to use for database.

USER VIDEO COMMENT
TABLE 1 TABLE 2 TABLE 3

These are the steps to create a database using the SQL but before that you need to learn first to situate the XAMPP and use it to begin creating and prospecting about database.

STEP 1: DOWNDLOADING XAMPP APACHE TO BROWSER:
For Windows user:
First go to Google chrome and search XAMPP APACHE

Second download the XAMPP APACHE.

Wait until the XAMPP APACHE is finish to download.

Third click the XAMPP installer and run it. Just follow the steps of the installing that indicated to XAMPP installer. Then if the XAMPP was already installed open it.

Then after you open the XAMMP
Click start with APACHE and MY SQL so that it will become admin.

STEP 4 : And then go to browser and type localhost /phpadmin

STEP 5 Creating Database
In creating a database first click the NEW button and choose name of you database and tables you want to specify to encode the important details of the database like names, address contact numbers and etc. and then click create.

STEP 6 Creating name and how many columns do you need to fill some important information of your Database. Then click GO

After you click the GO button this will it look like at picture below,

After that you can put your some information you want to put in your database. Just like this for example.

Then click SAVE at the bottom.
Then after creating your table this will look like and you can now insert your personal information on the database.

Table that you created that indicate the detail information’s. And now to insert some information go to INSERT.

Then after you put some important information click the GO button.

And then it will show that your data information was successfully inserted.

And click BROWSE to see your information that you inserted.