Hi everyone,
Plz help me in solving this problem.
Itried to create a table called assignment which gets keys from
other tables, here is the query i wrote
create table assignment(assignid varchar(10) not null primary key, assign
name varchar(30) not null, duedate date not null, summary text, corseid
varchar(
20) not null, secid varchar(10) not null,terms varchar(20) not null,fuse
varchar
(10) not null, foreign key(fuse) references
faculty(fuserid),INDEX(secid,terms),
foreign key(secid,terms) references class(sectionid,term),foreign
key(corseid)
references class(courseid));
in the end, im getting the error displayed below.
when i ran "show innodb status" it says that there is no index to secid and
terms" i dint understand wat it means. plz provide me a solution to it. Its
driving me crazy .
Thank u
ERROR 1005 (HY000): Can't create table '.\db\assignment.frm' (errno: 150)
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
[Non-text portions of this message have been removed]
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
