Bug #3769 | Delimiter Command Missing in 5.0 alpha | ||
---|---|---|---|
Submitted: | 15 May 2004 4:00 | Modified: | 15 May 2004 17:00 |
Reporter: | Paul Tremblett | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
Version: | 5.0 alpha | OS: | Windows (Windows XP Pro) |
Assigned to: | CPU Architecture: | Any |
[15 May 2004 4:00]
Paul Tremblett
[15 May 2004 5:28]
MySQL Verification Team
Microsoft Windows XP [versão 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. c:\servers\5.0.0\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> delimiter | mysql> select version()| +----------------+ | version() | +----------------+ | 5.0.0-alpha-nt | +----------------+ 1 row in set (0.13 sec) mysql> delimiter ; mysql> select version(); +----------------+ | version() | +----------------+ | 5.0.0-alpha-nt | +----------------+ 1 row in set (0.00 sec) mysql>
[15 May 2004 6:17]
Paul DuBois
It's true that the delimiter command isn't listed in the 5.0.0 help message. But the command does work. The omission from the help message has been corrected and it will appear in 5.0.1.
[15 May 2004 6:30]
MySQL Verification Team
New Comment: Paul the version I have on my machine which was installed using our package is already included: C:\servers\5.0.0\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> \? For the complete MySQL Manual online visit: http://www.mysql.com/documentation For info on technical support from MySQL developers visit: http://www.mysql.com/support For info on MySQL books, utilities, consultants, etc. visit: http://www.mysql.com/portal List of all MySQL commands: Note that all text commands must be first on line and end with ';' help (\h) Display this help. ? (\?) Synonym for `help'. clear (\c) Clear command. connect (\r) Reconnect to the server. Optional arguments are db and host. ego (\G) Send command to mysql server, display result vertically. exit (\q) Exit mysql. Same as quit. go (\g) Send command to mysql server. notee (\t) Don't write into outfile. print (\p) Print current command. prompt (\R) Change your mysql prompt. quit (\q) Quit mysql. rehash (\#) Rebuild completion hash. source (\.) Execute a SQL script file. Takes a file name as an argument. status (\s) Get status information from the server. tee (\T) Set outfile [to_outfile]. Append everything into given outfile. use (\u) Use another database. Takes database name as argument. delimiter (\d) Set query delimiter. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ For server side help, type 'help all' mysql>
[15 May 2004 15:11]
Paul DuBois
Miguel: I see, you're right. But it's included at the end of the list of commands (it's out of order), so it's easy to miss.
[15 May 2004 15:51]
Paul Tremblett
When I start the command line client, it says my connection is to version 5. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 5.0.0-alpha-nt When I try the delimiter command, it does not work but simply displays -> indicating it's waiting for the delimiter \s shows: mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32) Connection id: 3 Current database: Current user: root@localhost SSL: Not in use Server version: 5.0.0-alpha-nt Protocol version: 10 Connection: localhost via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 6 min 22 sec Threads: 2 Questions: 46 Slow queries: 0 Opens: 6 Flush tables: 1 Open tabl es: 0 Queries per second avg: 0.120 Does the following look right for the contents of C:\mysql\bin? 02/11/2004 01:11 AM 155,648 comp-err.exe 02/11/2004 01:58 AM 669,150 cygwinb19.dll 02/11/2004 01:57 AM 282,624 isamchk.exe 12/22/2003 08:27 PM 937,984 libmySQL.dll 02/11/2004 01:57 AM 372,736 myisamchk.exe 02/11/2004 01:57 AM 290,816 myisamlog.exe 02/10/2004 10:26 PM 290,816 myisampack.exe 02/10/2004 10:26 PM 241,664 myisam_ftdump.exe 02/11/2004 01:57 AM 294,980 mysql.exe 02/11/2004 01:57 AM 249,856 mysqladmin.exe 02/11/2004 01:57 AM 258,048 mysqlbinlog.exe 02/11/2004 01:58 AM 334,712 mysqlc.exe 02/11/2004 01:57 AM 245,760 mysqlcheck.exe 12/22/2003 08:27 PM 3,907,584 mysqld-max-nt.exe 12/22/2003 08:27 PM 3,903,488 mysqld-max.exe 12/22/2003 08:27 PM 3,432,448 mysqld-nt.exe 12/22/2003 08:27 PM 3,428,352 mysqld-opt.exe 12/22/2003 08:27 PM 5,226,569 mysqld.exe 02/11/2004 01:58 AM 258,048 mysqldump.exe 02/11/2004 01:58 AM 241,664 mysqlimport.exe 02/11/2004 01:58 AM 241,664 mysqlshow.exe 02/11/2004 01:58 AM 45,056 mysqlwatch.exe 02/10/2004 10:26 PM 172,032 my_print_defaults.exe 02/11/2004 01:58 AM 241,664 pack_isam.exe 02/11/2004 01:58 AM 159,744 perror.exe 02/11/2004 01:58 AM 176,128 replace.exe 02/11/2004 01:58 AM 818 winmysqladmin.cnt 02/11/2004 01:58 AM 936,448 winmysqladmin.exe 06/19/2000 04:52 AM 1,856,816 WINMYSQLADMIN.HLP 29 File(s) 28,853,317 bytes
[15 May 2004 17:00]
Sergei Golubchik
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Additional info: duplicate of bug#3436
[15 May 2004 17:50]
Paul DuBois
Paul, you're connecting to a MySQL 5 server, but the client that you're using is too old. This is shown by what \s displays: \s shows: mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32) Please try it with the mysql client from 5.0.0, not the 4.0.18 client. The delimiter command is a client program command, not a server command.
[15 May 2004 22:04]
Paul Tremblett
Don't know why but the client I was running surely must have been older. I reinstalled 5.0 from scratch and now everything is working fine. Thanks