Hello Everyone,
I am having problems with foreign keys in MySQL InnoDB type databases.
For some reason, when adding a new record within an MS Access subform
(based on a query of two tables (parent table and child table), the
corresponding foreign key column in the child table not getting
Sonj McCoy wrote:
Hello Everyone,
I am having problems with foreign keys in MySQL InnoDB type databases.
For some reason, when adding a new record within an MS Access subform
(based on a query of two tables (parent table and child table), the
corresponding foreign key column in the child table
Scott Purcell [EMAIL PROTECTED] wrote:
I am trying to create some tables that I can use the delete on cascade =
function for. This would help me code the project and ensure data =
integrity. I am on the docs @ =
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html but I am =
not
Hello,
I am trying to create some tables that I can use the delete on cascade function for.
This would help me code the project and ensure data integrity. I am on the docs @
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html but I am not quite
understanding the syntax.
I am
sql query
Subject: Innodb Foreign Key Problems.
From: Scott Wong
Date: Wed, 5 Feb 2003 10:03:17 -0800
Hi. Simple parent/child table generates some weird output based on the order
possible bug?
Mysql 3.23.54
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE
Hi. Simple parent/child table generates some weird output based on the order
possible bug?
Mysql 3.23.54
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES
: a foreign key constraint fails
mysql
mysql update pickup_points set PP_RecordId = 10;
ERROR 1217: Cannot delete a parent row: a foreign key constraint fails
mysql
...
From: My Deja ([EMAIL PROTECTED])
Subject: InnoDB foreign key problems - is Heikki out
Hi.
I am using MySQL 3.23.44-max and InnoDB tables.
I also using foreign key in my tables.
I have problem, I couldn't alter my table and add any foreign keys.
SQL like this: alter table data_entry add FOREIGN KEY (data_task_id) REFERENCES
data_task(identity);
give me any error but key doesn't
