Bug #2254 Some backslash commands are missing
Submitted: 2 Jan 2004 3:26 Modified: 30 Jan 2004 9:56
Reporter: Jakub Vrána (Candidate Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.0.17 OS:Windows (Windows)
Assigned to: MySQL Verification Team CPU Architecture:Any

[2 Jan 2004 3:26] Jakub Vrána 
Description:
Some backslash commands (like \G) are not available in Windows version of mysql command-line tool (both mysql.exe and mysqlc.exe)

How to repeat:
mysql.exe
\h
[2 Jan 2004 3:48] MySQL Verification Team 
I don't understand what exactly you mean; e.g below the option \G you
said that isn't available.

mysql> select version()\G
*************************** 1. row ***************************
version(): 4.0.17-nt
1 row in set (0.00 sec)
[2 Jan 2004 4:13] Jakub Vrána 
Sorry for mismatch. It is missing only in mysqlc.exe:

C:\Program Files\MySQL\bin>mysqlc
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.0.17-nt

Type 'help' for help.

mysql> \h

MySQL commands:
help    (\h)    Display this text
?       (\h)    Synonym for `help'
clear   (\c)    Clear command
connect (\r)    Reconnect to the server. Optional arguments are db and host
edit    (\e)    Edit command with $EDITOR
exit    (\ )    Exit mysql. Same as quit
go      (\g)    Send command to mysql server
print   (\p)    print current command
quit    (\q)    Quit mysql
rehash  (\#)    Rebuild completion hash
status  (\s)    Get status information from the server
use     (\u)    Use another database. Takes database name as argument

Connection id: 7  (Can be used with mysqladmin kill)

mysql> select version()\G
ERROR: Unknown command '\G'.
[2 Jan 2004 5:08] MySQL Verification Team 
Yes the mysqlc.exe has missed these commands options.
[30 Jan 2004 9:56] Michael Widenius 
The reason for this is that mysqlc.exe is a very old version of the mysql command line client compiled with cygwin.

The only reason we keep it around is that the command line editing is a bit better in it.  We should probably do a new build of this, but as we don't have an active cygwin environment we have not been able to do this for some time.