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 not
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
popula
"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
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 creati
nnobase Oy
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
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 parent
pickup_points set PP_Code = 'frobboz';
ERROR 1217: Cannot delete a parent row: 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: M
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 crea
