Thursday, 3 March 2011

MYSQL DATABASE

First you  create database in your MYSQL from this site http://localhost/phpmyadmin 
than create database name (user) for login file. .



create database tables. .login and attributes username and password.
or copy this query. .
CREATE TABLE `user`.`login` (`username` VARCHAR(255) NOT NULL, `password` VARCHAR(255) NOT NULL) ENGINE = InnoDB; 



Insert data into table. 
or copy this query. .
INSERT INTO `user`.`login` (`username`, `password`) VALUES ('test', 'test'),VALUES('username','password');


 that's it. .

No comments:

Post a Comment