[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