Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

You will find that MySQL is priced well below its competitors. At the time of this writing,

Microsoft's SQL Server is priced at $28,999.00 for the Enterprise Edition with an

unlimited number of clients. The Enterprise Edition of Sybase Adapter 12 with a 10-seat

license sells for $1,650.00 for Windows NT. The Linux version of Sybase Adaptive Server

sells for $995. MySQL, on the other hand, is at most $200.

2. Go to Web sites or test some products that use MySQL. (Some are included on the
   CD-ROM.) Seeing MySQL in action can really change one's mind about open
   source products.

Support Wizard is a great example. It uses MySQL very efficiently.

Day 2

1. Using the command line, display all the data in the mysql database.

You can do this by using the following SQL command:

SELECT * FROM mysql;

2. You can also use the SHOW command. This will show all the tables in the database
   (SHOW TABLES FROM database_name).
   Check to see if the mysqld is running using two different methods.
   The first way is to use the mysqladmin command.
   bin/mysqladmin –p ping
   The other way is to grep (on Linux and UNIX machines) or to look at the processes or
   services that are currently running by pressing Ctrl+Alt+Delete (in Windows).
   ps -aux | grep mysqld


3. Telnet to a remote site and start and stop the MySQL server.
   From the command line, start a Telnet session connecting to the computer that is
   currently running MySQL. After you have established a connection, change directories to
   the mysql installation directory (/usr/local/mysql, by default). You must have
   MySQL root privileges to start and stop the server. To do this, use the mysqladmin
   shutdown command. To start it up again, use the safe_mysqld& command.


4. Use the MySQL monitor remotely.

This can be accomplished by using Telnet to connect to a remote MySQL server.

Day 3

1. In the Meet-A-Geek project, we defined several business objects. Can you define any
   more objects?

Based on interviews with the client, you can develop more business objects. For the

Meet_A_Geek database, they might be a Shipper object, Advertisement object,

Coupon object, or maybe a Credit Check object.

2. Come up with the rest of the business rules for the Meet-A-Geek project.

Additional business rules would also depend on interviews with the client or further study

of the business process. Some rules might include "A transaction cannot be committed

until a form of payment is verified." Another possible rule could be that an item will not be

shipped unless the item is available in inventory.

Day 4

1. Create and drop databases using the mysqladmin utility as well as using the
   monitor.

To create the database, use the following:

bin/mysqladmin –p CREATE DATABASE TestDB

To drop the database, use the following:

bin/mysqladmin –p DROP DATABASE TestDB

To experience the same results using the MySQL monitor program, use the following

commands:

CREATE DATABASE TestDB;

DROP DATABASE TestDB;