Create, Select and Insert into table

1. To create a table : create table table_name(col_name_1 data_type,........col_name_n data_type);
   For example:- Create a table  Bank with cols Account Number, Account Holder Name and Balance in account.
                              
   create table bank(account_number int,account_holder_name varchar(20),balance int);
   
   output:- Table Created.
   
2. To insert data into table : insert into table_name values(value_1,value_2,.......value_n);
   For example:- Insert data into Bank table.
   
   insert into bank values(101,'A',3000);
   insert into bank values(102,'B',4000);
   insert into bank values(103,'C',5000);
   insert into bank values(104,'D',6000);
   insert into bank values(105,'E',7000);
   insert into bank values(106,'F',8000);
   
   output:-
   1 Row Created
   1 Row Created
   1 Row Created
   1 Row Created
   1 Row Created
   1 Row Created
   
3. To Select data from table : select *from table_name;
   For example:- Select all data from Bank table
   
   select *from bank;
   
   output:-
   
   
   6 rows selected
   
   Another example :- Select only account_number and account_holder_name from table bank.
   
   select account_number,account_holder_name from bank;
   
   Output:-
   
                      .
   6 rows selected