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
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,
Fr
check your permissions for the user, perhaps the create table permission is
missing or the permissions need to be flushed to take effect
bastien
From: aconite <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] error creating tables
Date: Tue, 27 Feb 2007 03:58:23 -0800 (PST
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
