SQL DATABASE PRACTICE:
//database creation
create database userlogin; <!----Give the at any name -->//
use userlogin;After create the database use the use and give the
database name, the ur database changed and u can create in the table.otherwise u cannot create in the table;
LESSON TWO:
//table creation
create table user(
id int(11) unsigned auto_increment primary key not null,
username varchar(25) not null,
passwd varchar(25) not null,
email varchar(40) not null);
// if u table the show
show tables;
// table describe er jonno
describe user;//Give the name of the table after describe then semicolon and enter okay//
//Insert data in the table
INSERT INTO user(username, passwd, email) values('primetuber', '123445', 'abc254@gmail.com');
INSERT INTO user(username, passwd, email) values('primeki', '1235', 'ap254@gmail.com');
INSERT INTO user(username, passwd, email) values('prij', 'pa35', 'pa@gmail.com');
INSERT INTO user(username, passwd, email) values('jail', 'ja21', 'jh21@gmail.com');
INSERT INTO user(username, passwd, email) values('Md San', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md kawser', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md provo', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md jon', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md kal', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md lop', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md hou', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md lou', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md kij', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md dif', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md dip', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md ass', 'san21', 'san@gmail.com');
LESSON ONE:
//database creation
create database userlogin;
use userlogin;
LESSON TWO:
//table creation
create table user(
id int(11) unsigned auto_increment primary key not null,
username varchar(25) not null,
passwd varchar(25) not null,
email varchar(40) not null);
// if u table the show
show tables;
// table describe er jonno
describe user;
//Insert data in the table
INSERT INTO user(username, passwd, email) values('primetuber', '123445', 'abc254@gmail.com');
INSERT INTO user(username, passwd, email) values('primeki', '1235', 'ap254@gmail.com');
INSERT INTO user(username, passwd, email) values('prij', 'pa35', 'pa@gmail.com');
INSERT INTO user(username, passwd, email) values('jail', 'ja21', 'jh21@gmail.com');
INSERT INTO user(username, passwd, email) values('Md San', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md kawser', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md provo', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md jon', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md kal', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md lop', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md hou', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md lou', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md kij', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md dif', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md dip', 'san21', 'san@gmail.com');
INSERT INTO user(username, passwd, email) values('Md ass', 'san21', 'san@gmail.com');