開発環境
- OS: OS X Lion - Apple
- データベース言語: SQL
- リレーショナルデータベース: MySQL
『初めてのSQL』(Alan Beaulieu 著、株式会社クイープ 翻訳、オライリー・ジャパン、2006年、ISBN4-87311-281-8) の4章(フィルタリング), 4.5(練習問題)4-4を解いてみる。
4-4.
入出力結果(Terminal)
$ mysql -u lrngsql -p bank Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.24 MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show tables; +----------------+ | Tables_in_bank | +----------------+ | account | | branch | | business | | customer | | department | | employee | | individual | | officer | | product | | product_type | | tmp | | transaction | +----------------+ 12 rows in set (0.02 sec) mysql> desc customer; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | cust_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | fed_id | varchar(12) | NO | | NULL | | | cust_type_cd | enum('I','B') | NO | | NULL | | | address | varchar(30) | YES | | NULL | | | city | varchar(20) | YES | | NULL | | | state | varchar(20) | YES | | NULL | | | postal_code | varchar(10) | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 7 rows in set (0.05 sec) mysql> desc individual; +------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+-------+ | cust_id | int(10) unsigned | NO | PRI | NULL | | | fname | varchar(30) | NO | | NULL | | | lname | varchar(30) | NO | | NULL | | | birth_date | date | YES | | NULL | | +------------+------------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql> select cust_id,fname,lname -> from individual -> where lname like '_a%e%'; +---------+---------+--------+ | cust_id | fname | lname | +---------+---------+--------+ | 1 | James | Hadley | | 9 | Richard | Farley | +---------+---------+--------+ 2 rows in set (0.03 sec) mysql> select cust_id,fname,lname -> from individual; +---------+----------+---------+ | cust_id | fname | lname | +---------+----------+---------+ | 1 | James | Hadley | | 2 | Susan | Tingley | | 3 | Frank | Tucker | | 4 | John | Hayward | | 5 | Charles | Frasier | | 6 | John | Spencer | | 7 | Margaret | Young | | 8 | Louis | Blake | | 9 | Richard | Farley | +---------+----------+---------+ 9 rows in set (0.00 sec) mysql> quit; Bye $
0 コメント:
コメントを投稿