hi guyz
im stuck bad ....
i cant create tables, the tables which had NO foreign keys or they didmt
refer to another table were created fine
but the ones WITH foreign key ... refferring to fieldz in other table(s)
cant be created
mysql>create table lang ( lang_id int auto_increment primary key,
lang_ char(20)
);
query ok, 0 rows effected
mysql>create table usr_inf ( foreign key lang_id refrences lang(lang_id),
);
gives me this error :
error 1064: u ve an error in ur sql syntex near 'refrences lang(lang_id)'at
line 1
i even tried this without (lang_id) but it still doesnt work
where m i messing it up guyz ????
id really appriciate any help on this ....
thnx a million ... all of u ....
stuck bad
toby .....
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php