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" <frank@xxxxxxxxxx>, haber iletisinde sunlari
yazdi:E3FFFA30-3B52-48F5-90F2-C2CFDD6A657C@xxxxxxxxxxxxx
> 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, php-db-digest-help@xxxxxxxxxxxxx wrote:
>
>> From: aconite <thkniazi@xxxxxxxxx>
>> Date: February 27, 2007 3:58:23 AM PST
>> To: php-db@xxxxxxxxxxxxx
>> 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
