Sorry I forgot to give reference code for my explaination:

CREATE TABLE user (
uid SMALLINT NOT NULL,
login VARCHAR (12),
passw VARCHAR (12),
KEY (uid),
KEY (uid),
KEY (passw)
);Hello all,
I currently have an account with a hosting service (they donot provide Php and Mysql support) that provides phpMyAdmin 2.0.1 system. The main problem I am trying to solve is how do I insert the following KEY expressions using the phpMyAdmin 2.0.1 software?. Entering the uid, login and passw is no problem using inserting a new field. Do I have to use insert new fields as well to input the KEY functions ?

Regards

Richard