Database Commands

.........

....

to create a table (DDL)

create table table_name (

id number,

name varchar(20),

age number,

dob date

);

....................................

to insert data into the table (DML)

insert into table_name values(101,'md mainul hasan',22,'05-Jan-1999')

.....................................

data gula use korte chaile //// retrieve korte chaile

necessary commands

SELECT

FROM

WHERE their nickname is clause

"*" ei sign er mane Everything/ALL

SELECT * (SELECT ALL)

FROM table_name

WHERE ( if er mto kaj kore,, condition dite chaile eta use krbo)

.....

full table prints

SELECT * FROM table_name;

.....

full table chaina koyekta column er data dekhte chai,, sekhetreee

SELECT id,name FROM table_name;

...

sudhu "kuddus" er nam and id dekhte chai,,,sekhetreee

SELECT id, name FROM table_name WHERE name='Kuddus';

RifatEWU