|
2. The Database
The MySQL database 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,
index(password),
index(username))
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.
|
|
