14 SQL S Q L S Q L I n t e r n e t S Q L 7 S Q L S Q L i n s e r t u p d a t e s e l e c t d e l e t e c r e a t e a l t e r d r o p S Q L S Q L 14.1 S Q L Ti t l e A u t h o r Number of Pages P u b l i s h e r I S B N b o o k s authors p u b l i s h e r s
14 SQL 215 1 4-1 a u t h o r s p u b l i s h e r s b o o k s 14-1 14.2 14-1 S Q L 14-1 create_table.sql b o o k s a u t h o r s p u b l i s h e r s S Q L
216 PHP3 b o o k s a u t h o r s p u b l i s h e r s a u t h o r s p u b l i s h e r s 14-2 14-3 14-2 create_publishers.sql p u b l i s h e r s S Q L k e y _ p u b l i s h e r s i n s e r t
14 SQL 217 b o o k s I n s i d e - O u t s i d e Pilip Jose F a r m e r B e r k e l e y k e y _ a u h t o r s S Q L S Q L 3 S Q L B e r k e l e y k e y _ p u b l i s h e r s 1 b o o k s 14-4 14-4 create_books.sql b o o k s S Q L S Q L Larry Niven Tom Doherty Associates
218 PHP3 b o o k s S E L E C T b o o k s a u t h o r s 14.3 Red Hat S Q L s t a t e s b u s i n e s s e s W H E R E ( j o i n ) s t a t e _ n a m e b o o k s k e y _{ t a b l e n a m e } S Q L i n t ( 5 ) S Q L { }.{ } O R A C L E
14 SQL 219 6 0 a u t h o r s b o o k s Terry Pratchett 14.4 b o o k s books.key_authors1 books.key_authors2 a u t h o r s 3 90 % 90 b o o k s k e y _ a u t h o r s 2 3 4 a u t h o r s S Q L S Q L S Q L s p o u s e s b o o k s _ a u t h o r s b o o k a u t h o r
220 PHP3 b o o k s p u b l i s h e r s S Q L b o o k s _ a u t h o r s b o o k k e y _ a u t h o r s, a u t h o r s b o o k s _ a u t h o r s 14-5 S Q L b o o k s 14-5 14-5 create_books_authors.sql b o o k s _ a u t h o r s S Q L S Q L S Q L 3 k e y _ b o o k s Men at Arms H T M L S E L E C T
14 SQL 221 W H E R E F R O M The Death of Sleep GROUP BY p u b l i s h e r s F R O M H AV I N G
222 PHP3 S Q L a u t h o r s S Q L n a m e k e y _ a u t h o r s S Q L 14.5 M y S Q L 7. 12 7 F R O M W H E R E S Q L S E L E C T 14.5.1 S Q L Playground of the Mind A B (left join) b o o k s
14 SQL 223 14.5.2 M y S Q L (natural left join) S Q L W H E R E 14.5.3 Using W H E R E left join u s i n g ()
224 PHP3 14.6 N U L L S Q k e y _ p u b l i s h e r s N U L L M y S Q L 0, key_publishers int(5) DEFAULT '0' NOT NULL, D E FA U LT ' 0 ' b o o k s b o o k s _ a u t h o r s Playground of the Mind k e y _ a u t h o r s N U L L M y S Q L is NULL =NULL E r i c
14 SQL 225 S Q L N U L L 14.7 b o o k _ a u t h o r s S Q L Primary table Related table Primary key Foreign key b o o k s b o o k s a u t h o r s S Q L M y S Q L M y S Q L 5. 3. 5. 1
226 PHP3 14.8 S Q L S E L E C T s t a t e _ n a m e Red Hat Software,Inc. S E L E C T S Q L S Q L
14 SQL 227 group by h a v i n g c o u n t M y S Q L F R O M W H E R E N U L L I n t e r n e t