Electronic Books

)
??? The mysql client can be tricky
if you??™re not used to it. If you
have any problems, check out
the MySQL manual, a book on
MySQL, or this book??™s support
site at www.dmcinsights.com/
ajax/. Many people fi nd phpMy-
Admin, also used in this chapter,
to be an easier option.
make the database p. 4
??? If you??™re using MySQL on a
hosted Web site, your host will
likely provide you with phpMy-
Admin access. They may or may
not let you create databases,
though. If not, just use the database
you have already (assuming
it does not have tables called
departments and employees).
??? A database??™s collation refers to
the types of language characters
the database will support. If
you don??™t specify a collation, the
MySQL default collation will be
used. This is normally fi ne.
creating the database 9
make the tables p. 5
??? Both tables are defi ned in a
minimalist way. You can add
columns if you??™d like, but you??™ll
need to change the INSERT
commands (later in the chapter)
accordingly.
??? The SQL commands in this chapter,
and all of the book??™s code,
can be downloaded from www.


Pages:
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30