coolex Posted September 17, 2006 Share Posted September 17, 2006 Hello! I saw this MySQL Code in a PHP Script:CREATE TABLE `transaction` ( `ID` int(11) NOT NULL auto_increment, `sourceID` int(11) NOT NULL default '0', 'comment' varchar(200), PRIMARY KEY (`UID`), KEY `sourceID` (`sourceID`) )I know what a Foreign Key is. But what does "KEY `sourceID` (`sourceID`)" mean? Is it something like a Foreign key?Hope you can help me. Thank you. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 17, 2006 Share Posted September 17, 2006 KEY is just a synonym for INDEX. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.