Re: Foreign Keys Problem

On Thu, Nov 19, 2009 at 9:34 PM, Ye Yuan yuan4...@gmail.com wrote: Hi Victor, It looks to me the foreign key syntax is wrong. Can you create the Relationship table on your database by using below ddl? create table if not exists Relationship (ID integer auto_increment primary key, Parent

Foreign Keys Problem

Hi; I don't claim to be an expert in MySQL. The following code was largely supplied to me by someone who was. I don't really understand foreign keys. He wrote this off the top of his head, and it's throwing an error. Here's the python code: def catTree(): user, passwd, db, host = login()

Re: innofb foreign keys problem

Natale, - Original Message - From: Natale Babbo [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, January 15, 2003 9:33 AM Subject: innofb foreign keys problem # - 3rd post - # # - PLEASE HELP -- # hi to all, is it still true

Re: innodb foreign keys problem

Heikki Tuuri wrote: In the future, MySQL might do the following: in CREATE TABLE abbaguu ( ... FOREIGN KEY (column1) REFERENCES frobboz (column2) ) TYPE=InnoDB; it could check if there is a suitable index in abbaguu. If not, it would create the index automatically. For what its worth, and

innofb foreign keys problem

# - 3rd post - # # - PLEASE HELP -- # hi to all, is it still true that mysql/innodb needs explicit index creation on foreign keys? why can't i use a standard syntax for foreign keys creations? i have a database schema (ddl) with over 50 tables and i was trying

Re: innofb foreign keys problem

On Tue, 14 Jan 2003 16:41:06 +0100 (CET) Natale Babbo [EMAIL PROTECTED] wrote: # - 3rd post - # # - PLEASE HELP -- # hi to all, is it still true that mysql/innodb needs explicit index creation on foreign keys? Yes why can't i use a standard syntax

Re: innofb foreign keys problem

CIMEN [EMAIL PROTECTED] ha scritto: There are no other way you have to create the index first - Original Message - From: Natale Babbo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 5:41 PM Subject: innofb foreign keys problem # - 3rd post

RE: innofb foreign keys problem

To: Okan CIMEN; [EMAIL PROTECTED] Subject: Re: innofb foreign keys problem many thanks for your reply. then i ask me: why mysql needs explicit creation instead of create itself what it needs? manually creating the index seems to be a big complication (for big databases) and a waste of time. don't you

Re: innofb foreign keys problem

then i ask me: why mysql needs explicit creation instead of create itself what it needs? manually creating the index seems to be a big complication (for big databases) and a waste of time. don't you think so? it's a bug or a wanted feature? why? I agree with you 100%. A foreign key,as its

Re: innofb foreign keys problem

it's easy to *think* your app is working correctly when it could in fact be trashing referential integrity. From: Natale Babbo [EMAIL PROTECTED] Subject: innofb foreign keys problem Date: 15/01/2003 2:41:06 To: [EMAIL PROTECTED] # - 3rd post - # # - PLEASE