ATUS \G
>
> And look for the "LATEST FOREIGN KEY ERROR" section. It'll explain the
> reason for the (errno: 150) message.
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: wabiko.takuma [mailto:wab...@sysrdc.ns-sol.co.jp]
> Sent: Fr
35 AM
To: mysql@lists.mysql.com
Subject: foreign keys: Cannot create InnoDB table
Hi, All,
I can't create InnoDB table with foreign key constraints using more than 3
colmuns.
When I create table `test_fk`.`tbl1`, it gives me:
Can't create table 'test_fk.tbl1' (errno: 1
Hi,
I can't create InnoDB table with foreign key constraints using more than 3
colmuns.
When I create table `test_fk`.`tbl1`, it gives me:
Can't create table 'test_fk.tbl1' (errno: 150)
why? CREATE TABLE syntax looks perfectly right to me.
Any suggestions are welcome.
Thank you,
wabi
--
Hi, All,
I can't create InnoDB table with foreign key constraints using more than 3
colmuns.
When I create table `test_fk`.`tbl1`, it gives me:
Can't create table 'test_fk.tbl1' (errno: 150)
why? CREATE TABLE syntax looks perfectly right to me.
Any suggestions are welcome.
Thank you,
wabi
Philip,
the problem is probably that the table already exists in the InnoDB internal
data dictionary. With 4.0.17, I get:
mysql> CREATE TABLE ids (id varchar(255)) TYPE=InnoDB;
ERROR 1005 (0): Can't create table './test/ids.frm' (errno: 121)
mysql>
Output to the .err log:
031112 17:48:3
I have a situation using InnoDB where I cannot create even the most
basic of tables with a given name.
mysql> create table card_batch ( a int );
ERROR 1005: Can't create table './test_gn/card_batch.frm' (errno: 121)
mysql> show tables like 'card%';
Empty set (0.01 sec)
mysql> show variables lik
