|
|
|
|
| |
These two queries look similar, but the first one fails because the parenthesis doesn't immediately follow the function name.
Another way to terminate a query is to use \g rather than a semicolon:
mysql> SELECT NOW()\g
Or you can use \G, which displays the results in vertical format:
mysql> SELECT NOW(), USER(), VERSION()\G
*************************** 1. row ***************************
NOW(): 2002-09-01 13:56:58
USER(): sampadm@localhost
VERSION(): 4.0.4-beta-log
For a query that generates short output lines, \G is not so useful, but if the lines are so long that they wrap around on your screen, \G can make the output easier to read.
If you've begun typing in a multiple-line query and decide you don't want to execute it, type \c to clear (cancel) it:
mysql> SELECT NOW(),
-> VERSION(),
-> \c
mysql>
|
|
|
|
|
|
| Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist |
|
