Re: Re: Altering table which has FOREIGN KEY constraints

2003-03-13 Thread Heikki Tuuri
;Victoria Reznichenko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, March 12, 2003 7:32 PM Subject: re: Re: Altering table which has FOREIGN KEY constraints > On Wednesday 12 March 2003 02:30, Heo Jungsu wrote: > > > > What do you mean "could

re: Re: Altering table which has FOREIGN KEY constraints

2003-03-12 Thread Victoria Reznichenko
On Wednesday 12 March 2003 02:30, Heo Jungsu wrote: > > What do you mean "could not execute a query on those tables"? > > Could you be more detailed? > > Ok. let me explain. > > When I was using MySQL 4.0.10, > > After I add columns with "ALTER TABLE" on foreign key referencing table so > many tim

Re: Altering table which has FOREIGN KEY constraints

2003-03-11 Thread Heo, Jungsu
n MySQL 4.0.11. - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 10, 2003 10:32 PM Subject: re: Altering table which has FOREIGN KEY constraints > On Saturday 08 March 2003 09:09, Heo Jungsu wrote: &g

re: Altering table which has FOREIGN KEY constraints

2003-03-10 Thread Victoria Reznichenko
On Saturday 08 March 2003 09:09, Heo Jungsu wrote: > I have a question about altering table which has foreign key constraints. > > MySQL manual says that : > > "In InnoDB versions < 3.23.50 ALTER TABLE or CREATE INDEX should not be > used in connection with tables which have foreign key constraint