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`) );
Advertisements
Ads
Ads