Re: [PHP-DB] error creating tables

[Haydar TUNA]

Hello,
I tried to run your SQL query with my private database and there 
wasn't any problem. You can use primary key like your PHP code because I run 
your SQL in the mysql command line succesfully. Did you connect root account 
to your mysql server? If the account is root, there isn't any problem. if 
the accout isn't root, you should check your user privileges.


-- 
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net

Frank Flynn [EMAIL PROTECTED], haber iletisinde sunlari 
yazdi:[EMAIL PROTECTED]
 Good rule - to debug try to run the same command on the command line
 of the terminal tool, you'll get better errors.

 But I suspect you have not said what the PRIMARY KEY is - typically
 you would say: PRIMARY KEY(f_name, l_name)
 or perhaps account whatever, it should be unique.

 Good Luck,
 Frank

 On Feb 27, 2007, at 3:58 AM, [EMAIL PROTECTED] wrote:

 From: aconite [EMAIL PROTECTED]
 Date: February 27, 2007 3:58:23 AM PST
 To: php-db@lists.php.net
 Subject: error creating tables



 im trying to create a database in a php file.i have MySql 5.0.33
 PHP 5.2.1
 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
 -- 
 View this message in context: http://www.nabble.com/error-creating-
 tables-tf3300307.html#a9180499
 Sent from the Php - Database mailing list archive at Nabble.com.



 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] error creating tables

[aconite]

im trying to create a database in a php file.i have MySql 5.0.33 PHP 5.2.1
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
-- 
View this message in context: 
http://www.nabble.com/error-creating-tables-tf3300307.html#a9180499
Sent from the Php - Database mailing list archive at Nabble.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php