[debian-mysql] Bug#427101: mysql help: last on line
Dan Jacobson
jidanni at jidanni.org
Fri Jun 1 21:19:20 UTC 2007
Package: mysql-client-5.0
Version: 5.0.38-3
Severity: wishlist
File: /usr/bin/mysql
mysql> ?
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear command.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
"First on line"? You mean "last on a line"!
Also some don't work, e.g.,
SELECT * FROM wiki_site_stats ego;
is just like with no ego. Must use \G, and ego needs a ";" which \G
doesn't but no mention is made.
Should give examples.
P.S., the LIMIT SQL documentation does not say how to get e.g., the
last 10 rows of the output,
* The `LIMIT' clause can be used to constrain the number of rows
returned by the `SELECT' statement. `LIMIT' takes one or two
numeric arguments, which must be integer constants...
without doing extra calculations.
Hmmm, file:///usr/share/doc/postgresql-doc-8.2/html/queries-limit.html
tells me it is not that simple. OK, never mind.
More information about the pkg-mysql-maint
mailing list