Database Reference
In-Depth Information
Verify that the rows were added to the
limbs
table by executing a
SELECT
statement:
mysql>
SELECT * FROM limbs;
+--------------+------+------+
| thing | legs | arms |
+--------------+------+------+
| human | 2 | 2 |
| insect | 6 | 0 |
| squid | 0 | 10 |
| fish | 0 | 0 |
| centipede | 100 | 0 |
| table | 4 | 0 |
| armchair | 4 | 2 |
| phonograph | 0 | 1 |
| tripod | 3 | 0 |
| Peg Leg Pete | 1 | 2 |
| space alien | NULL | NULL |
+--------------+------+------+
At this point, you're all set up with a database and a table. For additional information
about executing SQL statements, see Recipes
1.5
and
1.6
.
In this topic, statements show SQL keywords such as
SELECT
or
IN
SERT
in uppercase for distinctiveness. That's only a typographical
convention; keywords can be any lettercase.
1.3. What to Do if mysql Cannot Be Found
Problem
When you invoke
mysql
from the command line, your command interpreter can't find
it.
Solution
Add the directory where
mysql
is installed to your
PATH
setting. Then you can run
mysql
from any directory easily.
Discussion
If your shell or command interpreter can't find
mysql
when you invoke it, you'll see
some sort of error message. It might look like this under Unix:
%
mysql
mysql: Command not found.
Or like this under Windows: