Reply to Re: Can't create table

Your name:

Reply:


Posted by Fernand St-Georges on 06/28/05 22:20

Because you are in MySql


"blumi" <test@me.com> a �crit dans le message de news:
d9roip$m29$1@news.net.uni-c.dk...
>I get this error when I try to create the following tables:
>
>
> ERROR 1005 (HY000): Can't create table '.\haps\transcript.frm' (errno:
> 150)
>
> create table teaching (
> ProfId int,
> CrsCode varchar(10),
> Semester varchar(10),
> primary key(ProfId, CrsCode, Semester)
> ) engine=InnoDB;
>
>
> create table transcript (
> StudId int,
> CrsCode varchar(10),
> Semester varchar(10),
> primary key(StudId, CrsCode, Semester),
> foreign key(CrsCode, Semester) references teaching(ProfId, CrsCode,
> Semester)
> ) engine=InnoDB;
>
> What am I doing wrong??
>
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация