Thursday, 17 March 2011

creating the database

CREATE TABLE login_membership

(UserId int(4) NOT NULL auto_increment,
Username VARCHAR(70) NOT NULL,
Password VARCHAR(70) NOT NULL,
PRIMARY KEY (UserId));

INSERT INTO `login_membership` VALUES (1, 'siobhan', 'password1');

INSERT INTO `login_membership` VALUES (2, 'jimi', 'password2');



No comments:

Post a Comment