# perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed
What does table1 look like?
abdulazeez alugo wrote:
>
> Yeah I used the mysql_error and it returned Can't create table '.\website\table2.frm'
> (errno: 150). So what does that say?
>
>
>
>
>
>
>> Date: Tue, 7 Apr 2009 17:38:59 +0400
>> From: evgeniy@stripped
>> To: defatigue@stripped
>> CC: mysql@stripped
>> Subject: Re: PHP-MYSQL Question
>>
>> Perhaps you don't have permissions to create tables?
>>
>> It would have been much clearer if your script was like this:
>>
>> $result=mysql_query($your_create_table_statement);
>> if($result){ print"Successful";}
>> else {print "Unsuccessful: ".mysql_error()}
>>
>>
>> abdulazeez alugo wrote:
>>> Hi guys,
>>>
>>> Please can anyone tell me what I'm doing wrong with the code below? It keep
>>> returning unsuccessful.
>>>
>>> $result=mysql_query("CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY
>>> AUTO_INCREMENT,
>>> table1_id INT NOT NULL,
>>> name VARCHAR(100) NOT NULL,
>>> school VARCHAR(100) NOT NULL,
>>> comment TEXT NOT NULL,
>>> entrydate TIMESTAMP NOT NULL,
>>> FOREIGN KEY(table1_id) REFERENCES table1(table1_id))
>>> ENGINE = INNODB" );
>>>
>>> if($result){ print"Successful";}
>>> else {print "Unsuccessful";}
>>>
>>> Thanks in advance. Cheers.
>>>
>>> Alugo Abdulazeez.
>>>
>>> _________________________________________________________________
>>> More than messages–check out the rest of the Windows Live™.
>>> http://www.microsoft.com/windows/windowslive/
>>
>> --
>> С уважением,
>> Евгений Косов
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>
>
> _________________________________________________________________
> Invite your mail contacts to join your friends list with Windows Live Spaces. It's
> easy!
>
> http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
--
С уважением,
Евгений Косов
