Page 247 - PYTHON-12

After opening MySQL, the screen of the MySQL command prompt appears where you need to
specify a password to work with it.

After entering the password, the MySQL prompt appears, where you start typing the SQL commands,
as shown in Fig. 12.17. In order to come out of MySQL application, you can type quit in front of the
mysql> command prompt, as shown in Fig. 12.18.

Fig. 12.17: MySQL Prompt

This will close the MySQL

Fig. 12.18: Closing MySQL

Learning Tips:
Relational Database and SQL
1. Some database systems require a semicolon (;) at the end of each SQL statement.
2. Semicolon is the standard way to separate each SQL statement in database systems that allows more than
one SQL statement to be executed in the same call to the server.
3. SQL is NOT case-sensitive; select is the same as SELECT.

12.17