Re: Re: Altering table which has FOREIGN KEY constraints

2003-03-13 Thread Heikki Tuuri
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 not execute a query on those tables? Could you be more detailed

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 times, when I

Re: Altering table which has FOREIGN KEY constraints

2003-03-11 Thread Heo, Jungsu
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: I have a question about altering table which has foreign key constraints. MySQL manual says

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 constraints or