The MySQL database (you will need Windows hosting) used for this example has a simple three field table named members. The SQL query used to create the table is shown below:
CREATE TABLE members (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
password VARCHAR(12) NOT NULL,
username VARCHAR(12) NOT NULL,
As can be seen above the "id" is the primary key and is auto incremental. The "username" and "password" fields are both indexed and must have a value to enter a valid record. Now add a User to this table.