The RENAME syntax is correct, please see the following documentation: http://www.mysql.com/doc/R/E/RENAME_TABLE.html
-----Original Message----- From: SubbaReddy M [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 5:23 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Suspected Bug I am afraid it's not a bug, rather a syntax error. please follow the syntax to rename the table: mysql> alter table X1 rename as X2; Regards, ~ SubbaReddy .M ----- Original Message ----- From: "SubbaReddy M" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 15, 2002 3:46 PM Subject: Re: Suspected Bug > Yeah, for me also find error. > > -------------------------------------------------------------------------- -- > -------------------------- > mysql> create table X1(name varchar(10)); > Query OK, 0 rows affected (0.00 sec) > > mysql> insert into X1 values(5); > Query OK, 1 row affected (0.01 sec) > > mysql> RENAME TABLE X1 TO X2; > ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO > X2' at line 1 > mysql> > > -------------------------------------------------------------------------- -- > ---------------------------- > > > Regards, > > ~ SubbaReddy .M > Sr. Programmer, Frontlinesoft, Hyderabad > http://www.frontlinesoft.com > ICQ: 56093095 > > > ----- Original Message ----- > From: "Fred Lovine" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 15, 2002 12:23 PM > Subject: Suspected Bug > > > > MySQL is awesome, but I think I found a bug. > > > > The following script: > > > > CREATE TABLE X1 (x smallint); > > insert into X1 values(5); > > RENAME TABLE X1 TO X2; > > > > is producing the following error: > > > > 7 - Error on rename '.\<db>\X1.MY1' to '.\<db>\X2.MYI' (Errcode: 13) > > > > The problem seems to be caused by using uppercase table names. The problem > > does not happen when the table names are all lowercase. > > > > MySQL version: 3.23.47-nt > > Running on Windows 2000 Pro > > > > Feel free to contact me if there are any questions. > > > > Server Variables > > ---------------- > > Variable CLW Laptop > > back_log 50 > > basedir C:\CLW\MySQL\ > > binlog_cache_size 32768 > > character_set latin1 > > character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 > dos > > german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia > > hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 > > concurrent_insert ON > > connect_timeout 5 > > datadir C:\CLW\MySQL\data\ > > delay_key_write ON > > delayed_insert_limit 100 > > delayed_insert_timeout 300 > > delayed_queue_size 1000 > > flush OFF > > flush_time 1800 > > have_bdb NO > > have_gemini NO > > have_innodb NO > > have_isam YES > > have_raid NO > > have_openssl NO > > init_file > > interactive_timeout 28800 > > join_buffer_size 131072 > > key_buffer_size 8384512 > > language C:\CLW\MySQL\share\english\ > > large_files_support ON > > log OFF > > log_update OFF > > log_bin OFF > > log_slave_updates OFF > > log_long_queries OFF > > long_query_time 10 > > low_priority_updates OFF > > lower_case_table_names 1 > > max_allowed_packet 130048 > > max_binlog_cache_size 4294967295 > > max_binlog_size 1073741824 > > max_connections 100 > > max_connect_errors 10 > > max_delayed_threads 20 > > max_heap_table_size 16777216 > > max_join_size 4294967295 > > max_sort_length 1024 > > max_user_connections 0 > > max_tmp_tables 32 > > max_write_lock_count 4294967295 > > myisam_max_extra_sort_file_size 256 > > myisam_max_sort_file_size 2047 > > myisam_recover_options 0 > > myisam_sort_buffer_size 8388608 > > net_buffer_length 16384 > > net_read_timeout 30 > > net_retry_count 10 > > net_write_timeout 60 > > open_files_limit 0 > > pid_file C:\CLW\MySQL\data\laptop.pid > > port 3306 > > protocol_version 10 > > record_buffer 131072 > > record_rnd_buffer 131072 > > query_buffer_size 0 > > safe_show_database OFF > > server_id 0 > > slave_net_timeout 3600 > > skip_locking ON > > skip_networking OFF > > skip_show_database OFF > > slow_launch_time 2 > > socket MySQL > > sort_buffer 2097144 > > sql_mode 0 > > table_cache 64 > > table_type MYISAM > > thread_cache_size 0 > > thread_stack 65536 > > transaction_isolation READ-COMMITTED > > timezone Eastern Standard Time > > tmp_table_size 33554432 > > tmpdir C:\WINNT\TEMP\ > > version 3.23.47-nt > > wait_timeout 28800 > > > > > > Fred Lovine > > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > 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 > > > > > --------------------------------------------------------------------- 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
