Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post - MySQL

clifford · 07-26-2005, 07:23 PM

Hi,

I am starting to read up on buiding my own MySQL database for my site. What is the difference between an index, primary key and a foreign key? In the book I am reading by Kevin Yank (Build Your Own Database Driven Website Using PHP & MySQL) he refers to one or the other. Are they the same?

07-26-2005, 07:23 PM	#1 (permalink)
clifford Junior Member Join Date: Jun 2005 Location: Finland Posts: 26	MySQL - Indexes, Foreign Key, PK Hi, I am starting to read up on buiding my own MySQL database for my site. What is the difference between an index, primary key and a foreign key? In the book I am reading by Kevin Yank (Build Your Own Database Driven Website Using PHP & MySQL) he refers to one or the other. Are they the same?