MySQL Tutorial - page 35

Summary

The most important directories in your MySQL installation are bin (executable programs), data (database data), and docs (documentation).
The two programs you will use the most are mysqld, the MySQL server, and mysql, the command-line client.
You have a choice of several user interfaces/client programs. We discussed mysql (command-line), MySQLCC (GUI), and phpMyAdmin (Web-based).
The mysql command-line program has many useful command-line switches and options. We have discussed -u (to specify username), -p (to log in with a password), -h (to specify the host), and --i-am-a- dummy (for damage-control mode).
When logged in, you can use SHOW DATABASES or SHOW TABLES to get a list of what is in the system and DESCRIBE tablename to get information about a particular table.
You can log out with \q .
You can terminate commands with ; or \g to send them to the server for execution.
You can execute a file of commands from inside the client with source filename and from outside the client by using file redirection.

Quiz

1:	You would find the MySQL server program in the docs or Docs directory the lib directory the scripts directory the bin directory
2:	You would find the MySQL documentation in the docs or Docs directory the lib directory the scripts directory the bin directory
3:	You would find mysqlhotcopy in the docs or Docs directory the lib directory the scripts directory the bin directory
4:	Commands in the MySQL monitor should be terminated with a semicolon should be terminated with `\g` either a) or b) none of the above
5:	The `--i-am-a- dummy` option to the mysql executable means what it says prevents me from doing too much damage while learning SQL prevents me from doing anything at all other than logging in and out none of the above

Exercises

Q1:

Download and install a graphical or Web-based user interface such as MySQLCC. Work out how to log in and get a list of available databases using the client program you have chosen .

Answers

Quiz


A1:	d

A2:	a

A3:	c

A4:	c

A5:	b

In Chapter 3, "Database Design Crash Course," we will look at general database concepts, terminology, and design principles including normalization. If you are not new to databases but are new to MySQL, you can skim this chapter.

Part II: Designing and Creating Databases with MySQL

3 Database Design Crash Course

4 Creating Databases, Tables, and Indexes

Chapter 3. Database Design Crash Course

In this chapter we will review the basic principles of database design and normalization. A well-designed database minimizes redundancy without losing any data. That is, we aim to use the least amount of storage space for our database while still maintaining all links between data.

We will cover the following: