Thư viện tri thức trực tuyến
Kho tài liệu với 50,000+ tài liệu học thuật
© 2023 Siêu thị PDF - Kho tài liệu học thuật hàng đầu Việt Nam
Giáo trình SQL Đại Học Huế
Nội dung xem thử
Mô tả chi tiết
Giaïo trçnh thæûc haình SQL
7UDQJ
*,lv,7+,j8
64/ 6WUXFWXUHG4XHU\/DQJXDJH ODQJQQJ¤FVGX£QJFKRFDFK£TXDQ
WU F V GOL£X TXDQ K£ 1JQ QJ 64/ FKX Q ¤F D UD EL $16, $PHULFDQ
1DWLRQDO 6WDQGDUGV ,QVWLWXGH YD ,62 ,QWHUQDWLRQDO 6WDQGDUGV 2UJDQL]DWLRQ YL
SKLQ EDQ PL QK¢W KL£Q QD\ OD SKLQ EDQ 64/ SKLQ EDQ ¤F D UD QP
0£FGXFRQKLXQJQQJNKDFQKDX¤FDUDFKRFDFK£TXDQWU&6'/
TXDQK£64/ODQJQQJ¤FVGX£QJU¤QJUDLKL£QQD\WURQJU¢WQKLXK£WK¢QJ
&6'/WKQJPD£LQK2UDFOH64/6HUYHU'%0LFURVRIW$FFHVV7KQJTXD64/
QJL V GX£QJFRWK G¡ GDQJ QK QJKD ¤F GOL£XWKDRWDF YL GOL£X0£W
NKDF\ODQJQQJFRWQKNKDLEDRQQQRG¡VGX£QJYDFXQJYY£\PDWUQQ
SK EL¢Q
*LDRWULQKQD\QKPFXQJF¢SFKRED£QWDLOL£XWKDPNKDRWQJ¢L\XY
FDF FX O£QK JLDR WDF 64/ V GX£QJ FKR K£ TXDQ WU &6'/ 0LFURVRIW 64/ 6HUYHU
*LDRWUQKEDRJPE¢QFKQJ
&KQJ JLLWKL£XP¤W V¢ FXO£QK V GX£QJWURQJ YL£F QK QJKD FDF ¢L
W¤QJGOL£XQKEDQJGOL£XNKXQJQKQYDFKPX£F
&KQJ WUQK ED\ E¢Q FX O£QK WKDR WDF G OL£X OD 6(/(&7 ,16(57
83'$7(YD'(/(7( WURQJRW£SWUXQJFKX\¢XFXO£QK6(/(&7
&KQJF£S¢QKDLFXO£QKLXNKL QOD*5$17YD5(92.(VGX£QJ
WURQJYL£FF¢SSKDWYDKX\ERTX\QFXDQJLVGX£QJ&6'/
&KQJ JLL WKL£X Y WKX WX£F OX WU YD WULJJHU j\ OD QKQJ ¢L W¤QJ
&6'/¤FVGX£QJQKPWQJKL£XQQJNKLVGX£QJ&6'/
7URQJFKQJSKX£OX£FFKXQJWLJLLWKL£XF¢XWUXFYDGOL£XFXDFDFEDQJV
GX£QJWURQJFDFYGX£FKQJ ED£QWL£QWUDFXYD¢LFKL¢XYLFDFYGX£DQX
1JRDLUDWURQJFKQJQD\FRQFRFDFKDPWKQJVGX£QJWURQJ64/6HUYHUFDF
ED£QWKDPNKDRWURQJWK£FKDQK
0£FGXDU¢WF¢JQJQKQJJLDRWUQKNKQJWK WUDQKX¤FFDFVDLVRW5¢W
PRQJQK£Q¤FV£JRS\FXDFDFED£Q JLDRWUQKQJD\FDQJKRDQWKL£QKQ
Tráön Nguyãn Phong
Chæång 1: NGÄN NGÆÎÂËNH NGHÉA DÆÎLIÃÛU
1JQQJQKQJKDGOL£XEDRJPFDFFXO£QKFKRSKHSQJLVGX£QJQK
QJKD&6'/YDFDF¢LW¤QJWURQJ&6'/QKFDFEDQJFDFNKXQJQKQFKPX£F
7DREDQJGOL X
'OL£XEQWURQJP¤W&6'/¤FW FKFOXWUWURQJFDFEDQJ%QWURQJFDF
EDQJGOL£X¤FW FKFGLGD£QJFDFGRQJYDFDFF¤W0¡LP¤WGRQJEL XGL¡Q
P¤WEDQJKLGX\QK¢WYDP¡LP¤WF¤WEL XGL¡QFKRP¤WWUQJ
&DFWKXFWQKOL QTXDQ QEDQJ
.KLWD£R YDODP YL£F YLFDF EDQJ GOL£XWDFQ SKDL \ ¢QFDFWKX¤FWQK
NKDFWUQEDQJQK NL XGOL£XFDF UDQJEX¤FFDFNKRDFDFTXLWF&DFWKX¤F
WQKQD\¤FVGX£QJQKPWD£RUDFDFUDQJEX¤FWRDQYH£QWUQFDFF¤W WUQJ WUQ
EDQJFXQJQKWD£RUDFDFWRDQYH£QWKDPFKL¢XJLDFDFEDQJGOL£XWURQJ&6'/
D.L XGOL X
0¡LP¤WF¤W WUQJ FXDP¤W EDQJ X SKDLWKX¤F YDRP¤W NL X GOL£X QK¢W
QKD¤FQKQJKDWWUF0¡LP¤W NL X GOL£X TXL QK FDF JLDWU GOL£X
¤FFKRSKHS¢LYLF¤WR&DFK£TXDQWU&6'/WKQJFXQJF¢SFDFNL XGOL£X
FKX QQJRDLUDFRQFRWK FKRSKHSQJLVGX£QJQKQJKDFDFNL XGOL£XNKDF
G£DWUQFDFNL XGOL£XDFR
'L\ODP¤WV¢NL XGOL£XWKQJ¤FVGX£QJWURQJJLDRWDF64/
Binary
Bit
Char
Datetime
Decimal
Float
Image
Int
Money
Nchar
Ntext
Nvarchar
Real
Smalldatetime
Smallint
Smallmoney
Text
Tinyint
Varbinary
Varchar
E&DFUDQJEXF &21675$,176
7UQFDFEDQJGOL£XFDFUDQJEX¤F¤FVGX£QJQKPFDFPX£FFKVDX
• 4XLQKFDFJLDWUGOL£XKD\NKXQGD£QJGOL£X¤FFKRSKHSFK¢SQK£QWUQ
FDFF¤WFXDEDQJ UDQJEX¤F&+(&.
• 4XLQKJLDWUP£FQKFKRFDFF¤W UDQJEX¤F'()$8/7
Giaïo trçnh thæûc haình SQL
7UDQJ
• 7D£RQQWQKWRDQYH£QWK£FWK WURQJP¤WEDQJGOL£XYDWRDQYH£QWKDPFKL¢XJLD
FDF EDQJ G OL£X WURQJ &6'/ UDQJ EX¤F 35,0$5< .(< 81,48( YD
)25(,*1.(<
&KXQJWDVHWPKL XFKLWL¢WKQYFDFUDQJEX¤FQD\SKQWUQKED\YFXO£QK
&5($7(7$%/(
7DREDQJEQJWUX\YQ64/
7D£RFDFEDQJODP¤WNKXTXDQWURQJWUR¤QJWURQJ TXDWUQKWKL¢W N¢ YDFDL G£W
FDF&6'/%QWURQJFDF&6'/P¡LP¤WEDQJWKQJ¤FVGX£QJQKPEL XGL¡Q
WKQJWKLYFDF¢LW¤QJWURQJWK¢JLLWK£FYDKR£FEL XGL¡QP¢LTXDQK£JLDFDF
¢LW¤QJRj FRWK W FKFW¢WP¤WEDQJGOL£XED£QWQK¢WFQSKDL[DFQK
¤FFDF\XFXVDX
• %DQJ¤FVGX£QJQKPPX£FFKJYDFRYDLWURQKWK¢QDREQWURQJ&6'/"
• %DQJVHEDRJPQKQJF¤WQDRYDNL XGOL£XFKRFDFF¤WRODJ"
• 1KQJF¤WQDRFKRSKHSFK¢SQK£QJLDWU18//
• &RVGX£QJFDFUDQJEX¤FFDFP£FQKKD\NKQJYDQ¢XFRWKVGX£QJXYD
QKXWK¢QDR"
• 1KQJF¤WQDRVHRQJYDLWURODNKRDFKQKNKRDQJRDLNKRDGX\QK¢W"1KQJ
GD£QJFKPX£FQDRODFQWKL¢WYDFQX
D7DREDQJGOL X
j WD£RP¤W EDQJWURQJ&6'/ ED£Q V GX£QJ FXO£QK&5($7(7$%/( FR FX
SKDSQKVDX
CREATE TABLE table_name
(
{colname_1 col_1_properties [constraints_1 ]
[,{colname_2 col_2_properties [constraints_2 ]]
...
[,{colname_N col_N_properties [constraints_N ]]
[table_constraints]
)
7URQJR
- table_name: 7Q EDQJ FQ WD£R 7Q FXD EDQJ SKDL GX\ QK¢W
WURQJP¡L&6'/YDSKDLWXQWKHRFDFTXLWFY
QKGDQK
- colname_i: 7QFXDF¤WWKLWURQJEDQJ&DFF¤WWURQJP¡L
Tráön Nguyãn Phong
EDQJSKDLFRWQNKDFQKDXYDSKDLWXQWKHRFDF
TXL WF Y QK GDQK 0¡L P¤W EDQJ SKDL FR W
QK¢WP¤WF¤W
- col_i_properties: &DFWKX¤FWQKFXDF¤WWKLTXLQKNL XGOL£X
FXD F¤W YD FK QK F¤W FR FKR SKHS FK¢S QK£Q
JLDWU18//KD\NKQJ
- constraints_i: &DF UDQJ EX¤F Q¢X FR WUQ F¤W WK L QK FDF
UDQJEX¤FYNKRDFDFP£FQKFDFTXLQKY
NKXQGD£QJGOL£X
- table_constraint: &DFUDQJEX¤FWUQEDQJGOL£X
9GX &XO£QKGL\WK£FKL£QKYL£FWD£REDQJ1+$19,(1EDRJPFDFF¤W
0$19+27(11*$<6,1+',$&+,',(17+2$,
CREATE TABLE nhanvien
(
manv char(10) not null,
hoten char(30) not null,
ngaysinh datetime null,
diachi char(50) null,
dienthoai char(6) null
)
E6GXQJFDFUDQJEXFWURQJEDQJGOL X
D5DQJEXF&+(&.
5DQJEX¤F&+(&.¤FVGX£QJ FKQKFDFJLDWUKD\NKXQGD£QJGOL£X
FR WK ¤F FK¢S QK£Q ¢L YL P¤W F¤W 7UQ P¤W F¤W FR WK FR QKLX UDQJ EX¤F
&+(&.j NKDLEDRP¤WUDQJEX¤F&+(&.¢LYLP¤WF¤WQDRRWDVGX£QJFX
SKDSQKVDX
[CONSTRAINT constraint_name]
CHECK (expression)
7URQJRH[SUHVVLRQODP¤WEL XWKFORJLF TXL QK JLDWU KD\ NKXQ GD£QJFXD G
OL£X¤FFKRSKHS.KLRFKQKQJJLDWUGOL£XQDRODPFKRH[SUHVVLRQQK£QJLD
WUXQJPL¤FFK¢SQK£Q
9GX j TXL QK L£QWKRD£LFXD QKQ YLQ SKDLFR GD£QJ
FKQJ KD£Q
FXO£QKYGX£¤FYL¢WQKVDX
CREATE TABLE nhanvien
(