Creating a Table in MySQL : Table Create « MySQL Database « PHP

Creating a Table in MySQL


  $connection= mysql_connect ($host, $uname, $pass) or die ("Database connection failed!");

  $result=mysql_select_db ($database) or die ("Database could not be selected");
  $query = "create table ". $tablename ." (name varchar (20) Not Null, email varchar (40) Not Null)";
  $result = mysql_query ($query);
  if (! $result) {
    die ("Query could not be executed.");
  } else {
    echo $tablename." created in the megabase database.\n";

Related examples in the same category

1.Table-Creation Script
2.Create new table in MySQL
3.Create table and install data