database
DESCRIPTION
ip project mysql codingTRANSCRIPT
-
create database jsm;use jsm;------------------------------------------------------------------------------------CODE FOR login :-------------------------------------------------------------------------------------
create table login(username varchar(20) primary key,password varchar(15));-------------------------------------------------------------------------------------CODE FOR new_member :--------------------------------------------------------------------------------------
create table new_member(name varchar(15),fathname varchar(20), age int(3),occup varchar(15),email varchar(60));-------------------------------------------------------------------------------------CODE FOR tournament :--------------------------------------------------------------------------------------
create table tournament( srno int(5),ntourn varchar(15),t_date date,place varchar(15));\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\VALUES FOR tournament\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
insert into tournamentvalues(1,'honda cup','2016-02-05','delhi');
insert into tournamentvalues(2,'cricket matches','2016-02-11','jaipur');
insert into tournamentvalues(3,'swimming meet','2016-02-18','jaipur');
insert into tournamentvalues(4,'chess champ','2016-02-22','sikar');
insert into tournamentvalues(5,'hero cup','2016-02-26','jhodpur');