You can enter multiple statements on a single line and end each one with a semicolon: : Command « Introduction « MySQL Tutorial






mysql>
mysql> SELECT VERSION(); SELECT NOW();
+---------------------+
| VERSION()           |
+---------------------+
| 5.0.41-community-nt |
+---------------------+
1 row in set (0.00 sec)

+---------------------+
| NOW()               |
+---------------------+
| 2007-07-22 20:10:16 |
+---------------------+
1 row in set (0.00 sec)

mysql>








1.2.Command
1.2.1.You can enter multiple statements on a single line and end each one with a semicolon:
1.2.2.A simple multiple-line statement.
1.2.3.Prompts and their meaning
1.2.4.To cancel the command: type the '\c' command
1.2.5.The Most Important mysql Commands