Znam kako napraviti primery key(označi se gumb), al me zanima kako napraviti običan key u tablici pošto nemogu importirati tablicu u wamp
evo tablica koju želim rekonstruirat
CREATE TABLE Clients (
PkClient int(12) NOT NULL auto_increment,
Email varchar(255) NOT NULL default '',
Password varchar(255) NOT NULL default '',
Name varchar(255) NOT NULL default '',
Address varchar(255) NOT NULL default '',
City varchar(255) NOT NULL default '',
State varchar(255) NOT NULL default '',
Country varchar(255) NOT NULL default '',
Zip varchar(10) NOT NULL default '',
Phone varchar(15) NOT NULL default '',
SName varchar(255) NOT NULL default '',
SAddress varchar(255) NOT NULL default '',
SCity varchar(255) NOT NULL default '',
SState varchar(255) NOT NULL default '',
SCountry varchar(255) NOT NULL default '',
SZip varchar(10) NOT NULL default '',
SPhone varchar(15) NOT NULL default '',
Credit_Card varchar(255) NOT NULL default '',
Credit_Number varchar(255) NOT NULL default '',
Expiration date NOT NULL default '0000-00-00',
PRIMARY KEY (PkClient),
KEY Email(Email),
KEY Password(Password)
) TYPE=MyISAM;
Search
Member List
Calendar
Help
