MySQL:Using Help

Overview
The objective of this exercise is to make you familiar with how to executing some SQL commands and to use the online Help. The following exercises assume you are in the SQL environment.

MySQL Help
MySQL comes with a good range of documentation, which you can refer to in times of need. Documentation is available online. For MySQL 5.1 http://dev.mysql.com/doc/refman/5.1/en/

Documentation is also included with mysql. When you type in help the following is displayed.



From the information on the help screen and experimentation, answer the following:

Exercise 1:
List 4 ways to exit mysql.

Refining Help
You can view server documentation by typing help contents.  You can then get more detailed help by typing help with a category.

Exercise 2
Try typing help data types and then using the more detailed help describe each of the following data types (write a short note about each):
 * 1) DECIMAL
 * 2) CHAR
 * 3) BLOB
 * 4) DATE
 * 5) BOOLEAN

Exercise 3
Using the help data manipulation command find out about the following commands (write a short note about each):
 * 1) SELECT
 * 2) INSERT
 * 3) DELETE
 * 4) UPDATE
 * 5) SHOW
 * 6) CREATE DATABASE
 * 7) CREATE TABLE