Jump to content

error creating table???


aconite

Recommended Posts

im trying to create a database in a php file.

this is the code i have in the php file

 

$con = mysql_pconnect("127.0.0.1","root","12345");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

 

if (mysql_query("CREATE DATABASE mydatabase",$con))

  {

  echo 'Database created  ';

  }

else

  {

  echo "Error creating database: " . mysql_error();

  }

 

 

if(!mysql_select_db("mydatabase"))

{

die('Could not select database: mydatabase ' . mysql_error());

}

 

echo "Database selected    ";

 

if (mysql_query("CREATE TABLE customer

                            (f_name VARCHAR(15) NOT NULL,

    l_name VARCHAR(15) NOT NULL,

                              phone  VARCHAR(11) ,

                              account INT UNSIGNED PRIMARY KEY)")

  )

{

  echo 'table created';

  }

else

  {

  echo "  Error creating table: " . mysql_error();

  }

 

when i view this file in the browser i get

 

Database created Database selected Error creating table: Can't create table '.\mydatabase\customer.frm' (errno: 121)

 

any idea wht the prob is??

I did some reading and found it might have something to do with InnoDB. but i dont know what that is :-[ .If that is the prob can someone please explain InnoDB concept

Link to comment
https://forums.phpfreaks.com/topic/40220-error-creating-table/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.