Re: Foreign Keys Problem

On Thu, Nov 19, 2009 at 9:34 PM, Ye Yuan 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 integer not

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() datab

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 I

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 -- # &g

Re: innofb foreign keys problem

since 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 PROTE

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

RE: innofb foreign keys problem

: 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'

Re: innofb foreign keys problem

--- Okan 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, Janu

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

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