Certify and Increase Opportunity.
Be
Govt. Certified PHP-Developer
Table Creation

To create Database in MySQL:
Using MySQL console:
i)    Open MySQL console from WAMP server icon
ii)    Enter the password (generally it is blank, unless you have set any)
ii)    Type create database database_name. Enter your desired database name in place of database_name e.g. create database student or create database Employee etc. SQL is not a case sensitive language, but  database name or table name is case sensitive.  After that to open the database type use database_name

OR

Using phpMyAdmin:
i)    Start  WAMP server
ii)    Click on the icon you will get a menu
iii)    After clicking phpMyAdmin option, http://localhost/phpadmin/ page will be open.
iv) Select any appropriate name for your new database in the create new database textbox and click create button.

Creating A database With PHP
To create a table in PHP is slightly more difficult than with MySQL. It takes the following format:

<?php
$con = mysql_connect(“localhost”,”user1″,”password1″);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

if (mysql_query(“CREATE DATABASE my_db”,$con))
{
echo “Database created”;
}
else
{
echo “Error creating database: ” . mysql_error();
}

mysql_close($con);
?>

 

Table creation –

<?php
$con = mysql_connect(“localhost”,”user1″,”password1″);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

// Create database
if (mysql_query(“CREATE DATABASE my_db”,$con))
{
echo “Database created”;
}
else
{
echo “Error creating database: ” . mysql_error();
}

// Create table
mysql_select_db(“my_db”, $con);
$sql = “CREATE TABLE Persons
(
FirstName varchar(15),
LastName varchar(15),
Age int
)”;

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?>