Learning SQL Second Edition phần 1 docx

... context. 2004- 01- 22 $10 0.0 010 3DBT978 dateamountaccount_idtxn_type_cdtxn_id 2004-02-05$25.0 010 3CDT979 2004-03-09$250.0 010 4DBT980 2004-03-25 $10 00.0 010 5DBT9 81 2004-04-02 $13 8.5 010 5CDT982 2004-04-04$77.8 610 5CDT983 2004-03-27$500.0 010 6DBT984 Transaction $75.001CHK103 balancecust_idproduct_cdaccount_id $250.001SAV104 $783.642CHK105 $500.002MM106 02LOC107 Account BlakeGeorge1 l...

Ngày tải lên: 08/08/2014, 18:22

... YYYY-MM-DD 10 00- 01- 01 to 9999 -12 - 31 Datetime YYYY-MM-DD HH:MI:SS 10 00- 01- 01 00:00:00 to 9999 -12 - 31 23:59:59 Timestamp YYYY-MM-DD HH:MI:SS 19 70- 01- 01 00:00:00 to 2037 -12 - 31 23:59:59 Year YYYY 19 01 to 215 5 Time ... | | 8 | 2006 | | 9 | 2006 | | 10 | 2006 | | 11 | 2004 | | 12 | 2007 | | 13 | 2004 | | 14 | 2006 | | 15 | 2007 | | 16 | 2005 | | 17 | 2006 | |...

Ngày tải lên: 08/08/2014, 18:22

... | | 1 | MM | | 1 | CD | | 10 | CHK | | 10 | SAV | | 10 | CD | | 10 | CHK | | 10 | SAV | | 10 | CD | | 10 | BUS | | 13 | CHK | | 13 | MM | | 13 | SBL | | 16 | CHK | | 16 | CHK | | 16 | SAV | | 16 ... | | 1 | MM | | 1 | MM | | 1 | SAV | | 10 | BUS | | 10 | CD | | 10 | CD | | 10 | CHK | | 10 | CHK | | 10 | SAV | | 10 | SAV | | 13 | CHK | | 13 | MM | | 13 | SBL |...

Ngày tải lên: 08/08/2014, 18:22

... CHAR (13 8 ,13 9 ,14 0 ,14 1 ,14 2 ,14 3 ,14 4 ,14 5 ,14 6 ,14 7); + + | CHAR (13 8 ,13 9 ,14 0 ,14 1 ,14 2 ,14 3 ,14 4 ,14 5 ,14 6 ,14 7) | + + | ốùợỡẫổặụ | + + 1 row in set (0. 01 sec) mysql> SELECT CHAR (14 8 ,14 9 ,15 0 ,15 1 ,15 2 ,15 3 ,15 4 ,15 5 ,15 6 ,15 7); + ... currency symbols: mysql> SELECT CHAR (12 8 ,12 9 ,13 0 ,13 1 ,13 2 ,13 3 ,13 4 ,13 5 ,13 6 ,13 7); + + | CHAR (1...

Ngày tải lên: 08/08/2014, 18:22

... Functions | 14 9 Download at WoweBook.Com | 19 | 1 | | 1 | 10 | | 2 | 10 | | 3 | 10 | | 4 | 10 | | 5 | 10 | | 14 | 10 | | 22 | 10 | | 6 | 13 | | 7 | 13 | | 24 | 13 | | 11 | 16 | | 15 | 16 | | 16 | 16 | | ... data: mysql> SELECT open_emp_id -> FROM account; + + | open_emp_id | + + | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 10 | | 10 | | 1...

Ngày tải lên: 08/08/2014, 18:22

... 3 | 10 57.75 | | 8 | MM | 3 | 2 212 .50 | | 10 | CHK | 4 | 534 .12 | | 11 | SAV | 4 | 767.77 | | 12 | MM | 4 | 5487.09 | | 13 | CHK | 5 | 2237.97 | | 14 | CHK | 6 | 12 2.37 | | 15 | CD | 6 | 10 000.00 ... would be set to null. 18 0 | Chapter 9: Subqueries Download at WoweBook.Com | 10 | 4 | | 11 | 4 | | 12 | 4 | | 13 | 5 | | 14 | 6 | | 15 | 6 | | 17 | 7 | | 18 | 8 | | 19 |...

Ngày tải lên: 08/08/2014, 18:22

... account_id | cust_id | cust_type_cd | fed_id | + + + + + | 1 | 1 | I | 11 1 -11 -11 11 | | 2 | 1 | I | 11 1 -11 -11 11 | | 3 | 1 | I | 11 1 -11 -11 11 | | 4 | 2 | I | 222-22-2222 | | 5 | 2 | I | 222-22-2222 | | 6 ... 888-88-8888 | | 17 | 9 | I | 999-99-9999 | | 18 | 9 | I | 999-99-9999 | | 19 | 9 | I | 999-99-9999 | | 20 | 10 | B | 04 -11 111 11 | | 21 | 10 | B | 04 -11 1...

Ngày tải lên: 08/08/2014, 18:22

... ends in 8888 | I | | 9 | ends in 9999 | I | | 10 | ends in 11 1 | B | | 11 | ends in 222 | B | | 12 | ends in 333 | B | | 13 | ends in 444 | B | + + + + 13 rows in set (0.02 sec) The actual query ... fed_id | name | + + + + | 10 | ends in 11 1 | Chilton Engineering | | 11 | ends in 222 | Northeast Cooling Inc. | | 12 | ends in 333 | Superior Auto Body | | 13 | ends in 444 | AAA Ins...

Ngày tải lên: 08/08/2014, 18:22

... sec) mysql> PREPARE dynsql1 FROM @qry; Query OK, 0 rows affected (0.04 sec) Statement prepared mysql> EXECUTE dynsql1; + + + + | cust_id | cust_type_cd | fed_id | + + + + | 1 | I | 11 1 -11 -11 11 ... | | 10 | B | 04 -11 111 11 | | 11 | B | 04-2222222 | | 12 | B | 04-3333333 | | 13 | B | 04-4444444 | | 99 | I | 04-9999999 | + + + + 14 rows in set (0.27 sec) mysql> DEALLOCAT...

Ngày tải lên: 08/08/2014, 18:22

... 'I'; + + + + | account_id | fed_id | name | + + + + | 1 | 11 1 -11 -11 11 | checking account | | 2 | 11 1 -11 -11 11 | savings account | | 3 | 11 1 -11 -11 11 | certificate of deposit | | 4 | 222-22-2222 | checking ... function, 14 1 converting strings to temporal data types, 13 5 ceil( ) function, 12 8 char type, 19 , 11 3 char( ) function, 11 7 generating strings, 1...

Ngày tải lên: 08/08/2014, 18:22