MySQL Cookbook, 2nd Edition

Issuing SQL Statements

Problem

You’ve started mysql, and now you want to send SQL statements to the MySQL server to be executed.

Solution

Just type them in, but be sure to let mysql know where each one ends.

Discussion

When you invoke mysql, it displays a mysql> prompt to tell you that it’s ready for input. To issue a SQL statement at the mysql> prompt, type it in, add a semicolon (;) at the end to signify the end of the statement, and press Enter. An explicit statement terminator is necessary; mysql doesn’t interpret Enter as a terminator because you can enter a statement using multiple input lines. The semicolon is the most common terminator, but you can also use \g (“go”) as a synonym for the semicolon. Thus, the following examples are equivalent ways of issuing the same statement, even though they are entered differently and terminated differently:

mysql>SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2005-11-15 16:18:10 |
+---------------------+
mysql> SELECT
    -> NOW()\g
+---------------------+
| NOW()               |
+---------------------+
| 2005-11-15 16:18:18 |
+---------------------+

Notice that for the second statement the prompt changes from mysql> to -> on the second input line. mysql changes the prompt this way to let you know that it’s still waiting to see the statement terminator.

Be sure to understand that neither the ; character nor the \g sequence that serve as statement terminators are part of the statement itself. They’re conventions used by the mysql ...