Hello,
I understand the following with the exception of the line that reads UNIQUE KEY ID_2 (ID). When I look at the table created there is no such field as ID_2. Can someone tell me what that line is actually doing? Many thanks.
CREATE TABLE orders (
ID mediumint(9) NOT NULL auto_increment,
name varchar(80) NOT NULL default '',
order_code varchar(20) NOT NULL default '',
PRIMARY KEY (ID),
UNIQUE KEY ID_2 (ID),
UNIQUE KEY order_code (order_code),
KEY ID (ID),
) ;
