A problem with MySQLMan.
I have a table called "Soccer_League", which contains serval fields such as Country_code, League_code, Team1, Team2 and Match_date. The table was created already by another script. MySQLMan displays the property of this table, there are 5 index keys like as bellow:
keyname --- Unique --- field name
Soccer_league_index1 --- NO --- country_code
Soccer_league_index1 --- NO --- league_code
Soccer_league_index1 --- NO --- match_date
Soccer_league_index1 --- NO --- team1
Soccer_league_index1 --- NO --- team2
The problem is, when I browse this table, there is no edit/delete action for any records. So I want to set some unique keyname for fields. How can I set keynames like:
keyname --- Unique --- field name
Soccer_league_index1 --- YES --- country_code
Soccer_league_index1 --- YES --- league_code
Soccer_league_index1 --- YES --- match_date
Soccer_league_index1 --- YES --- team1
Soccer_league_index1 --- YES --- team2
or
keyname --- Unique --- field name
PRI --- YES --- country_code
PRI --- YES --- league_code
PRI --- YES --- match_date
PRI --- YES --- team1
PRI --- YES --- team2
MySQlMan doesn't allow me to do that ... but actually I saw some tables had this kind of keynames. What should I do?
Sorry for my English.
Thanks a lot.
I have a table called "Soccer_League", which contains serval fields such as Country_code, League_code, Team1, Team2 and Match_date. The table was created already by another script. MySQLMan displays the property of this table, there are 5 index keys like as bellow:
keyname --- Unique --- field name
Soccer_league_index1 --- NO --- country_code
Soccer_league_index1 --- NO --- league_code
Soccer_league_index1 --- NO --- match_date
Soccer_league_index1 --- NO --- team1
Soccer_league_index1 --- NO --- team2
The problem is, when I browse this table, there is no edit/delete action for any records. So I want to set some unique keyname for fields. How can I set keynames like:
keyname --- Unique --- field name
Soccer_league_index1 --- YES --- country_code
Soccer_league_index1 --- YES --- league_code
Soccer_league_index1 --- YES --- match_date
Soccer_league_index1 --- YES --- team1
Soccer_league_index1 --- YES --- team2
or
keyname --- Unique --- field name
PRI --- YES --- country_code
PRI --- YES --- league_code
PRI --- YES --- match_date
PRI --- YES --- team1
PRI --- YES --- team2
MySQlMan doesn't allow me to do that ... but actually I saw some tables had this kind of keynames. What should I do?
Sorry for my English.
Thanks a lot.