Capitulo6
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Capitulo6 as PDF for free.
More details
- Words: 795
- Pages: 6
%
&' ( ) $)
.) 3
% &
4
) /
* + $
$, # 0&
1
2
556786977:
! "
!
" #
INSE RT INT O
$
% &
#
& &
' ( &
NULL
)
! *
'
+
%
)
!
NULL
'
! ,
#
&
'
%
-
'
$
,
! !
) INSE RT INTO
+ %
' &
.
)
#
% '
/+0
+ +
5
#
#
1 / /+0+" 1 2 /! / 1 3 - 4 /+0+" 1 1 36 $ ! , 0 +" 786
! !$ $ (
!
1 :/ 0 : & 5 : $
36 + &
3 1(9 $
9
6
% 6 * -
2;* -;0 1*
<
1;=>20$ 1
6
2 /!
1
;&
! " &6 2
!
( 6?
2 /!
SELE CT.. .INT O
/
INSE RT I NTO
#
* -
2;* -;0
@ A
& E
%
@
* *
)
@
'
1
#
BBCB D/ .
A
@
@
&(
BC
!
(
'
' %
'
! NULL
'
VALU ES
'
' !
INSE RT INTO /
INSE RT INTO
'
#
)
!
( A : C ! %
2;* -;0
'
'
A
F F% C
A GC
!
E
NULL(
'
* -
!
A *
-
>
H/ C D/ .
A IJI : >
2
#
#:G87F 8IF 87GC
! ! ! %
* -
! '
!
!
2;* -;0
D/ .
A
(
/
2 #:
:G87F 8IF <887GC
! !
* -
2;* -;0
D/ .
A
/
NULL(
&
2 #:-.
-.
-.
G87F 8IF <887GC
%
2;* -;0 1;@ >20$
!
* -
)
&(
@ * B
B
@
'
@
#
'
B
SELE CT ... F ROM
!
'
' ; !
& '
!
'
* -
2;* -;0 1
1
1;=>20$ 1*
H/
1
H/
1 '
* -
%
!
2;* -;0 1
/
H1
1;=>20$ 1
%
(
H1
(
H/
&
! (
* -
2;* -;0 1;* 1 > * >20$ D L8 5M 2 > N 3 G87F 8OF <887G
*D
1
&
$
!/
'
#
& ' IN
' & &
$
!/
* /$
# A
C
'
' &
* - ;2
$
!/
'
&
;
* - ;1(9 $
* - ;;.$ /
' J8
#
!
'
* - ;;.$ / E +/;/"/ 32 & E 5+3 % 2
"/
+/;/"/
%
!
$ /
(
9 "L
;
E +/;/"/ 31(9 $ 9 "L E 5+3
!/
&
# '
% 2
* -
2;* -;0 1
1;=>20$ 1
)
* -
G
!* -: : @ "/
J8E +/;/"/
&
2;* -;0 1
/
G& * -: : @ ; P;E M+23Q E +/;/"/
31(9 $
9 B
(
31(9 $
9 B
1;=>20$ 1
! UPDA TE !
$ )
. +/;
! &
;
3
(
@
3
B 5M 2
!
# WHER E
' #
#
!
)
INSE RT IN TO
/ '
UPDA TE
#
& ! # '
. +/;
;
)
# <
3
;
L88 (
=L8<5M 2 R
3J
!
'
WHER E
#
!
(
. +/;
/
;
#
. +/;
3
=L8<
R
;R
3I
(
3 SIO8J5M 2 *
3 <7I
" M
%
! $
$ '
+
# E
DELE TE WHER E
!
'
FROM
&
'
(
+
; @
=B >20$ &
H
5M 2
DROP TABL E '
#
/
1
* *
! #
' DELE TE
'
' &
&
DELE TE
)
)
'
! NULL
#
! !
)
' DELE TE
#
! !
& '
1
1
A
C
>
' . A
C > DELE TE
/ ) )
)
! * $* -/2 +/;0
' '
+
; >20$
R
5M 2 R
3I
'
+
(
WHER E(
; >20$
/
> '
#
(
+ ; > >20$ 1 5M 2 1
= * -- 2 , 0* -> *1 3<JI
)
0- 1
*1
3>
*1
'
A
! C
'
A
C(
+ ; 1 >20$ 1 5M 2 1
=> = * -- 2 , 0* -> *1 3<JI
0- 1
*1
3>
*1
1
)
!#
#
+/0
'
1
0 &
$ )
!/ !
' !
)
>
( %
<"
( !( = # ;
/+0
)
%
!
)
* 0 977: ! .
) '
& !
4
4
!
Q
T!
&' ( ) $)
.) 3
% &
4
) /
* + $
$, # 0&
1
2
556786977:
! "
!
" #
INSE RT INT O
$
% &
#
& &
' ( &
NULL
)
! *
'
+
%
)
!
NULL
'
! ,
#
&
'
%
-
'
$
,
! !
) INSE RT INTO
+ %
' &
.
)
#
% '
/+0
+ +
5
#
#
1 / /+0+" 1 2 /! / 1 3 - 4 /+0+" 1 1 36 $ ! , 0 +" 786
! !$ $ (
!
1 :/ 0 : & 5 : $
36 + &
3 1(9 $
9
6
% 6 * -
2;* -;0 1*
<
1;=>20$ 1
6
2 /!
1
;&
! " &6 2
!
( 6?
2 /!
SELE CT.. .INT O
/
INSE RT I NTO
#
* -
2;* -;0
@ A
& E
%
@
* *
)
@
'
1
#
BBCB D/ .
A
@
@
&(
BC
!
(
'
' %
'
! NULL
'
VALU ES
'
' !
INSE RT INTO /
INSE RT INTO
'
#
)
!
( A : C ! %
2;* -;0
'
'
A
F F% C
A GC
!
E
NULL(
'
* -
!
A *
-
>
H/ C D/ .
A IJI : >
2
#
#:G87F 8IF 87GC
! ! ! %
* -
! '
!
!
2;* -;0
D/ .
A
(
/
2 #:
:G87F 8IF <887GC
! !
* -
2;* -;0
D/ .
A
/
NULL(
&
2 #:-.
-.
-.
G87F 8IF <887GC
%
2;* -;0 1;@ >20$
!
* -
)
&(
@ * B
B
@
'
@
#
'
B
SELE CT ... F ROM
!
'
' ; !
& '
!
'
* -
2;* -;0 1
1
1;=>20$ 1*
H/
1
H/
1 '
* -
%
!
2;* -;0 1
/
H1
1;=>20$ 1
%
(
H1
(
H/
&
! (
* -
2;* -;0 1;* 1 > * >20$ D L8 5M 2 > N 3 G87F 8OF <887G
*D
1
&
$
!/
'
#
& ' IN
' & &
$
!/
* /$
# A
C
'
' &
* - ;2
$
!/
'
&
;
* - ;1(9 $
* - ;;.$ /
' J8
#
!
'
* - ;;.$ / E +/;/"/ 32 & E 5+3 % 2
"/
+/;/"/
%
!
$ /
(
9 "L
;
E +/;/"/ 31(9 $ 9 "L E 5+3
!/
&
# '
% 2
* -
2;* -;0 1
1;=>20$ 1
)
* -
G
!* -: : @ "/
J8E +/;/"/
&
2;* -;0 1
/
G& * -: : @ ; P;E M+23Q E +/;/"/
31(9 $
9 B
(
31(9 $
9 B
1;=>20$ 1
! UPDA TE !
$ )
. +/;
! &
;
3
(
@
3
B 5M 2
!
# WHER E
' #
#
!
)
INSE RT IN TO
/ '
UPDA TE
#
& ! # '
. +/;
;
)
# <
3
;
L88 (
=L8<5M 2 R
3J
!
'
WHER E
#
!
(
. +/;
/
;
#
. +/;
3
=L8<
R
;R
3I
(
3 SIO8J5M 2 *
3 <7I
" M
%
! $
$ '
+
# E
DELE TE WHER E
!
'
FROM
&
'
(
+
; @
=B >20$ &
H
5M 2
DROP TABL E '
#
/
1
* *
! #
' DELE TE
'
' &
&
DELE TE
)
)
'
! NULL
#
! !
)
' DELE TE
#
! !
& '
1
1
A
C
>
' . A
C > DELE TE
/ ) )
)
! * $* -/2 +/;0
' '
+
; >20$
R
5M 2 R
3I
'
+
(
WHER E(
; >20$
/
> '
#
(
+ ; > >20$ 1 5M 2 1
= * -- 2 , 0* -> *1 3<JI
)
0- 1
*1
3>
*1
'
A
! C
'
A
C(
+ ; 1 >20$ 1 5M 2 1
=> = * -- 2 , 0* -> *1 3<JI
0- 1
*1
3>
*1
1
)
!#
#
+/0
'
1
0 &
$ )
!/ !
' !
)
>
( %
<"
( !( = # ;
/+0
)
%
!
)
* 0 977: ! .
) '
& !
4
4
!
Q
T!
