Skip to content GitLab
Find file Blame History Permalink
VideoLAN code repository instance Bài gi ả ng H ệ qu ả n tr ị CSDL Biên so ạ n: Chu Th ị H ườ ng B ộ môn: Các h ệ th ố ng thông tin Khoa Công ngh ệ Thông tin 1 M Ụ C L Ụ C C.............................................................................................................................1 Ch CSDL..........................................................3 1.1. Ð a:.................................................................................................................3 1.2. Các kh CSDL...........................................................................3 1.3. CSDL..........................................................................4 1.3.1. S u:...................................................................................4 1.3.2. Ngôn ng u........................................................................................5 1.3.3. X i.......................................................................................................6 1.3.4. Qu ch................................................................................................6 1.3.5. Qu .....................................................................................................7 1.4. Ki CSDL..........................................................................7 1.5. Các ch ....................................................9 1.5.2. Các ch ..................................................11 Ch N.....................................................................14 2.1. CÁC CÂU L U...........................................................14 2.1.1. L nh CREATE...................................................................................................14 2.1.2. L i ALTER...........................................................................15 2.1.3. Xoá c U...............................................................16 2.2.1. L nh Insert.........................................................................................................16 2.2.2. L nh Update.......................................................................................................16 2.2.2. L nh Delete........................................................................................................17 2.3. KI U............................................................................................17 2.3.1. Trao quy n GRANT..........................................................................................17 2.3.2. Thu h n REVOTE...................................................................................17 2.4. TRUY V U.............................................................................................18 2.4.1. Tìm ki n........................................................................18 2.4.2. S n..................................................................................19 2.4.3. Tìm ki ................................................................................20 2.4.4. Câu h p................................................................................................21 Ch u - Database....................................................................................45 3.2.2.B ng - Table........................................................................................................59 3.2.3. View...................................................................................................................67 |