|
Home > Archive > Microsoft SQL Server forum > June 2005 > Can't create table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can't create table
|
|
| blumi 2005-06-28, 11:23 am |
| 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??
| |
|
| For starters, you're posting in the wrong newsgroup :)
Try posting in the MySQL newsgroups, rather than the SQL Server groups,
and they might be help to give you better insight. However, this link
might point you in the right direction.
http://www.mysqlusers.com/msg/11638.html
HTH,
Stu
| |
| Fernand St-Georges 2005-06-28, 8:23 pm |
| 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??
>
>
|
|
|
|
|