Posts

Showing posts with the label DBMS

Create, Select and Insert into table

Image
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. 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 To Select data from table : select *from table_name; For example:- Select all data from Bank table select *from bank;...

SQL (Structure Query Language)

DDL : Data Definition Language                                                    ( i )    Create Table                                                    ( ii )   Alter Table                                                    ( iii )   Drop the table DML : Data Manipulation Language                                                    ( i )    Insert                           ...