>Description:
The manual says that starting from MySQL 3.23.6, any combination
of characters is allowed for a database name (excluding '/', ASCII(0) and
ASCII(255)). I created database that name consist only of numbers
using mysqladmin tool, but I was unable to drop it using mysql command
line client (neither I was able to create database with that kind of
name):
ERROR 1064: You have an error in your SQL syntax near '12345' at line 1
>How-To-Repeat:
mysqladmin create 12345
echo "drop database 12345" | mysql
>Release: mysql-3.23.33 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for -freebsd4.2
on i386
TCX Datakonsult AB, by Monty
Server version 3.23.33
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 11 min 28 sec
Threads: 2 Questions: 399824 Slow queries: 0 Opens: 24 Flush tables: 1
Open tables: 12 Queries per second avg: 581.140
>Environment:
<machine, os, target, libraries (multiple lines)>
System: FreeBSD commonwealth.interia.pl 4.2-RELEASE FreeBSD 4.2-RELEASE #1:
Fri Feb 23 12:39:22 CET 2001 [EMAIL PROTECTED]
ia.pl:/usr/src/sys/compile/COMMONWEALTH i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS='-mcpu=pentiumpro -march=pentiumpro'
CXX='c++' CXXFLAGS='-mcpu=pentiumpro -march=pentiumpro -fel
ide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1169076 Nov 20 12:59 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Feb 23 12:51 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 559196 Nov 20 12:59 /usr/lib/libc.so.4
Configure command:
./configure --localstatedir=/home/mysqld/data --without-perl --without-debu
g --without-readline --without-bench
--with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --
with-charset=latin2 --prefix=/usr/local/mysql i386--free
bsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd
--
------------------------------------------------------------------------
Maciek Dobrzanski [EMAIL PROTECTED]
INTERIA.PL @ http://www.interia.pl/ +48 (12) 638 07 70
ul. Krolewska 57, 30-081 Krakow
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
