mysql command.txt

show databases;
create database bankmanagemntsystem;
use bankmanagemntsystem;
create table signup (formno varchar(20), name varchar(50), fname varchar(50), dob varchar(20), gender varchar(10), email varchar(25), marital varchar(20), address varchar(50), city varchar(20), state varchar(20), pin varchar(20));
drop table signup;
show tables;
select * from signup;
select * from signuptwo;
select * from signupthree;
select * from login;
select * from bank;



create table signuptwo (form_number varchar(20), religional_status varchar(20), category varchar(20), income varchar(40), education varchar(50), occupation varchar(50), seniorcitizen varchar(20),pan_Number varchar(50), aadharnumber varchar(50), exiting_account varchar(50));
drop table signuptwo;




create table signupthree (form_number varchar(20), accountType varchar(40), cardnumber varchar(25), pin varchar(10), facility varchar(150));
drop table signupthree;


create table login (form_number varchar(20), cardnumber varchar(25), pin varchar(10)); 
drop table login;


create table bank (pin varchar(10),date varchar(50),type varchar(40), amount varchar(50) );

show tables;