SQL Bangla Tutorial.pdf


Preview of PDF document sql-bangla-tutorial.pdf

Page 1...4 5 67816

Text preview


  k  
e    e '   -  +  e - e0 k  # ,  
i  
 sn 0 # ,  
USE database_name( )  0 # ,  
database_name e я *  i 0 ( ( ।)
 B
e ap я     3  
 sn
DROP DATABASE database_name( )  0  3
database_name e я *  i 0 ( ( ।)
e      3   ,  
 )   2  (undo) m , i     -  я0  ,
)  p я 0  3 ( ।

e u ,    >2 ? u  (
u  ( SQL Tabl e Cr eat i on Tut or i al
i n Bangl a)
  :
 я  

  sn 0  m +
CREATE TABLE table_name( )    
table_name e я *  i 0 ( ( ।)u( , :
designer  )  0  3   k  (  ( ( )e6 SQL #  k   
  n0 
1.CREATE TABLE `designer`.`test` (
2.`id` INT( 10 )NOT NULL AUTO_INCREMENT PRIMARYKEY ,
3.`first name` VARCHAR( 15 ) NOT NULL ,
4.`last name` VARCHAR( 15 ) NOT NULL ,
5.`email` VARCHAR( 20 ) NOT NULL,
6.`course name` VARCHAR( 20 ) NOT NULL DEFAULT'WDAD',
7.`mobile` INT( 12 ) NOT NULL
8.)

e  GO   k  #  test  e   , )  designer database e a' ।