>Description:
create table user( u_id int(255) not null, name varchar(255));
Notice the lack of space between user and the ( if you add a space
in the statment will work. this problem only seems to happen when the
table is named user. create table blah( will work fine
>How-To-Repeat:
create table user( u_id int(255) not null, name varchar(255));
results in the folowing error
ERROR 1064: You have an error in your SQL syntax near 'user( u_id int(255) not n
ull, name varchar(255))' at line 1
note this was tested on win32 mysql version 3.23.32 and linux mysql version 3.23.32
>Fix:
add a space between user and (
>Submitter-Id: submitter ID
>Originator:
>Organization:
[EMAIL PROTECTED]
>MySQL support: none
>Synopsis: problem creating user table
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 11 days 15 hours 5 min 11 sec
Threads: 2 Questions: 14672 Slow queries: 0 Opens: 101 Flush tables: 1 Open
tables: 37 Queries per second avg: 0.015
>Environment:
System: Linux prop 2.2.18 #2 Tue Dec 12 16:43:49 CET 2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 17 1999 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4073346 Jan 31 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20110466 Jan 31 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 31 2000 /usr/lib/libc.so
-rw-r--r-- 2 root root 2087032 Feb 2 2000 /usr/lib/libc-client.a
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
'--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
