This book uses several conventions with regard to using the command line that are important to understand.
If code is listed without a prompt, it is assumed to be SQL and can be run in any MySQL client.
The shell> prompt indicates that the text following the prompt should be entered in your system's shell (Unix) or command window (Windows).
The mysql> prompt indicates that the text following the prompt should be entered in the mysql command-line client.
Whether entering commands at a shell prompt or within the MySQL command-line client, only enter the text that, in the book, follows the prompt. Do not enter the prompt itself.