CREATE DATABASE AND TABLE IN MYSQL

Hi …. Welcome again in my site… at We Are Knowledge.. 

In here you want getting many IT knowledge .. you can getting likely PHP, VB, HTML, MYSQL and other…

And now… I want giving you method for making “database” and “table” in MYSQL… This is very easy.. In manufacture “database” and “table” it you must having software or aplication “XAMPP”… and if you have it… Let’s check it…

Frist step you must open the XAMPP and trun on or start “mysql” you just click until word “start” be “stop”.. if it is open “Run” press windows + R… next write “cmd”.. >> Enter…

You must enter to folder or directories “xampp”. 

If you put instalitation in C:\program files\xampp…

Then you must write it

1. cd.. >> enter

2. cd.. >> enter

3. cd/program files/xampp/mysql/bin >> enter

4. mysql –u root >> enter

And ifit is… you can making “database”…

And syntax is : create database name_database;

If it is you can to making “table”

And syntax is :

Create table name_table;

Example :

1. Making database

Create database adsanse;

2. Making table

Create table adsanse(

Id int(9) primary key auto_increment,

Name varchar(200) not null,

Sex varchar(10),

Born date,

Adrress text

);

Logic ::

Primary key is address for different with other, this using for ‘id’ and should not be same

Auto_increment is value always incress though we not inputting.

Int to result variable integer value

Varchar to result variable character value

Date to result “date” yyyy – mm – dd

Text to result variable charcater and integer.. and unlimited….

Ok.. just it…

I hope you understand with this all…

Thanks for you and the readers….

If you not undestand please leaving the comment… and I want help you…

And if you like this article don’t forget to click button “like” “thumbs”….

Ok ok ok  See you later