SQL Bangla Tutorial.pdf


Preview of PDF document sql-bangla-tutorial.pdf

Page 1...6 7 891016

Text preview


e  a # # 2l*  2   2l #  - ।

e u pi ? u  ( SQL Pr i mar y Key Tut or i al i n Bangl a)
  :
 я  

1.e (  p0 entries  a #/ ( (uniquely) 
h /= k  ,।
2.+ e  e '   p i   ,   ( +  ।) i  ei p i    i +   p0
 (row)  a #/ ( (uniquely) 
h ।
3.)( e '   p i   ,    ,   *   e p i   .e  e i p i 
 - ।

5.p i   2  -  ।
5.  * 0u   ) 0    )( i  first name  p i       e  )(
 , я   -   ,    - o  - o e   -    ) o  m  3  ,
+ first name  last name  p i     e  16   +)n   e PRIMARY
KEY   )     o ) a # (unique) ,।eя # e  ) id number  PRIMARY
KEY ,   ,  ( iя  id   o e , ।e   a +  )  (first name,last name e
= = ,email e = = ii eL i# ( - )  J   ।

e u ,   ,+ B ( SQL Tabl e Del et e Show Tut or i al i n
Bangl a)
  :
 я  

SHOW TABLE ei sn 0 ( e     ( ) ।
DESCRIBE TABLE ei sn (  s  я +t ( ) ।) DESCRIBE test e0  
 0
( 
TABLE ALTERATI ON
  + = + = MYSQL e +  2 i   a  a+= +  )
1.alter table table_name add PRIMARY KEY (col_name,...)