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. Link to comment https://forums.phpfreaks.com/topic/21055-what-does-key-sourceid-sourceid-mean/ Share on other sites More sharing options...
fenway Posted September 17, 2006 Share Posted September 17, 2006 KEY is just a synonym for INDEX. Link to comment https://forums.phpfreaks.com/topic/21055-what-does-key-sourceid-sourceid-mean/#findComment-93509 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.