Skip to main content

Posts

Showing posts from June, 2021

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';