Creating a database
Posted on: February 12, 2011 at 12:00 AM
In This you will see the table of database driven application. And also learn how to create table in MySql

Creating database

At first create a database in MySql database named studentadmissionprocess then create a table stud_admission as

Use the SQL code to create table stud_admission

stud_admission  CREATE TABLE stud_admission(              
                  roll_no int(4) NOT NULL auto_increment,  
                  s_name varchar(15) NOT NULL,             
                  f_name varchar(20) NOT NULL,             
                  dob date NOT NULL,                       
                  c_date date NOT NULL,                    
                  class1 varchar(5) NOT NULL,              
                  address varchar(100) NOT NULL,           
                  phoneno varchar(10) NOT NULL,            
                  fee int(8) NOT NULL,                     
                  PRIMARY KEY  (`roll_no`)                   
                );

View of stud_admission table
 

Related Tags for Creating a database :

Advertisements

Ads

 
Advertisement null

Ads