>Description:
When one uses the "alter table tbl_name rename [to] new_tbl_name" command, it works
when "to" is not included in the command, but says there is an error in the SQL syntax
when "to" is included. My understanding is that "to" is optional and it should work
both ways.
>How-To-Repeat:
mysql> create table foo (id int);
Query OK, 0 rows affected (0.02 sec)
mysql> alter table foo rename to bar;
ERROR 1064: You have an error in your SQL syntax near 'to bar' at line 1
mysql> alter table foo rename bar;
Query OK, 0 rows affected (0.01 sec)
>Fix:
Don't use "to."
>Submitter-Id: <submitter ID>
>Originator: Geordy Kitchen
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.22.32 (Source distribution)
>Environment:
System: Linux okcomputer 2.2.17 #1 Sun Jun 25 09:24:41 EST 2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 20000220 (Debian GNU/Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
Configure command: ./configure --enable-shared --without-readline --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info
--includedir=/usr/include --mandir=/usr/share/man
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
