List:General Discussion« Previous MessageNext Message »
From:Adolfo Bello Date:December 8 2002 8:47pm
Subject:RE: May someone try this script under Mandrake 9 and Mysql 4.0.5
View as plain text  
Thanks a lot. I´ll stick to 3.23.53 until 4.0.6 appears.

Adolfo

> -----Original Message-----
> From: Heikki Tuuri [mailto:Heikki.Tuuri@stripped] 
> Sent: Sunday, December 08, 2002 4:21 PM
> To: mysql@stripped
> Subject: Re: May someone try this script under Mandrake 9 and 
> Mysql 4.0.5
> 
> 
> Adolfo,
> 
> ----- Original Message -----
> From: ""Adolfo Bello"" <adolfobello@stripped>
> Newsgroups: mailing.database.mysql
> Sent: Sunday, December 08, 2002 12:47 AM
> Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5
> 
> 
> > I have used a database creation script for months under 3.23.53a.
> >
> > Now, I want to upgrade to version 4.0.5 and the script 
> doesn't work. 
> > The first table is created but mysql complains with:
> >
> > Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
> > (errno:150)
> >
> > = = = SCRIPT TO TRY = = =
> > CREATE TABLE tblbasregiones(
> > intregion INTEGER PRIMARY KEY,
> > strregion VARCHAR(30) NOT NULL
> > ) TYPE=InnoDB ;
> >
> > CREATE TABLE tblbasestados( // this is line 10
> > intestado INTEGER PRIMARY KEY,
> > strestado VARCHAR(50) NOT NULL,
> > intregion INTEGER NOT NULL,
> > INDEX(intregion),
> > FOREIGN KEY (intregion)
> > REFERENCES tblbasregiones(intregion)
> > ON DELETE RESTRICT ON UPDATE CASCADE
> > ) TYPE=InnoDB ;
> > = = = END OF SCRIPT = = =
> >
> > I just can't spot what's wrong and want to know if there is 
> something 
> > wrong in my installation.
> 
> InnoDB does not support ON UPDATE CASCADE yet, though the 
> support may be available already in 4.0.6.
> 
> 3.23 just ignores the ON UPDATE clause, but 4.0.5 gives an 
> error 150 from it.
> 
> > Thanks in advance,
> >
> > Adolfo
> 
> Best regards,
> 
> Heikki Tuuri
> Innobase Oy
> ---
> Order technical MySQL/InnoDB support at 
> https://order.mysql.com/ See > http://www.innodb.com for the 
> online manual and latest news on InnoDB
> 
> sql query
> 
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread126937@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-adolfobello=bisapi.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 
> 

Thread
May someone try this script under Mandrake 9 and Mysql 4.0.5Adolfo Bello7 Dec
Re: May someone try this script under Mandrake 9 and Mysql 4.0.5Heikki Tuuri8 Dec
  • RE: May someone try this script under Mandrake 9 and Mysql 4.0.5Adolfo Bello8 Dec