 | | | Bookbiz DB | Bookbiz DB 2006-06-29 - By Karl Larsen
Back
I have been just reading the book and doing the examples and
learning how good MySQL is. I was early asking about Query and now I'm
doing it like the SQL says to do it. A recient one is like this:
mysql> SELECT au_lname, phone
-> FROM authors
-> WHERE phone LIKE '415%';
+-- ---- ----+-- ---- ------+
| au_lname | phone |
+-- ---- ----+-- ---- ------+
| Bennet | 415 658-9932 |
| Green | 415 986-7020 |
| Carson | 415 548-7723 |
| Stringer | 415 843-2991 |
| Straight | 415 834-2919 |
| Karsen | 415 534-9219 |
| MacFeather | 415 354-7128 |
| Dull | 415 836-7128 |
| Yokomoto | 415 935-4228 |
| Hunter | 415 836-7128 |
| Locksley | 415 585-4620 |
+-- ---- ----+-- ---- ------+
11 rows in set (0.07 sec)
The book does not use capital letters for SQL key words. I learned it is
a good idea to do this so when you read this it is obvious what is going
to happen.
When you have multiple SELECT and get an output from several tables you
see the power of SQL.
Karl Larsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|