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
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
MySQL - row,table level locking?
Hello Guru, I am web programmer using PERL, MySQL. I need help from you, could you please clarify my doubt? 1. How many methods or functions in PERL-DBI/DBD module will actually will get communicates with MySQL? I know one that's $sth-fecth() or $sth-fetchArrayref() after $sth-execute(); where $sth = $dbi-open(dbi:mysql:...); 2. Is it possible to Row level lock and Table level lock in MySQL, if yes, How could we achieve this in PERL-DBI ? Please, kindly clarify. Thanks in advance. ~ SubbaReddy .M Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - 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
Re: How to get connected with mysql using perl scripts
Hi, Check the following links: http://dbi.symbolstone.org/ http://www.saturn5.com/~jwb/dbi-examples.html http://www.oreilly.com/catalog/perldbi/ Best of luck. ~ SubbaReddy .M E-mail: [EMAIL PROTECTED] W3Page: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 1:51 PM Subject: How to get connected with mysql using perl scripts Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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
Re: Urgent Help needed
was specified explicitly.) With the C API function mysql_info(), you can find out how many records were copied, and (when IGNORE is used) how many records were deleted due to duplication of unique key values. The FOREIGN KEY, CHECK and REFERENCES clauses don't actually do anything. The syntax for them is provided only for compatibility, to make it easier to port code from other SQL servers and to run applications that create tables with references. See section 5.3 Functionality missing from MySQL. Here is an example that shows some of the uses of ALTER TABLE. We begin with a table t1 that is created as shown below: mysql CREATE TABLE t1 (a INTEGER,b CHAR(10)); To rename the table from t1 to t2: mysql ALTER TABLE t1 RENAME t2; To change column a from INTEGER to TINYINT NOT NULL (leaving the name the same), and to change column b from CHAR(10) to CHAR(20) as well as renaming it from b to c: mysql ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20); To add a new TIMESTAMP column named d: mysql ALTER TABLE t2 ADD d TIMESTAMP; To add an index on column d, and make column a the primary key: mysql ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a); To remove column c: mysql ALTER TABLE t2 DROP COLUMN c; To add a new AUTO_INCREMENT integer column named c: mysql ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD INDEX (c); Note that we indexed c, because AUTO_INCREMENT columns must be indexed, and also that we declare c as NOT NULL, because indexed columns cannot be NULL. When you add an AUTO_INCREMENT column, column values are filled in with sequence numbers for you automatically. Best of luck. ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Karuku Srinivas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 1:12 PM Subject: Urgent Help needed Hi All, Can anyone please tell me how to alter a table wherin modify a column (which is Unique) to a non unique column. Any help on this would be great . Thanks Regards, K Srinivas res Ph:6631851 ATS TransLogic Systems 5th Floor Amogh Plaza, Greenlands, Hyderabad, AP 500 016, India Tel: +91-40-3401795 x30 Fax: +91-40-3407943 http://www.translogicsys.com Logic that Works. - 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
Re: How to get connected with mysql using perl scripts
And here some more good links for DBI: http://www.he.net/adm/mysql/chapter7.html http://www.he.net/adm/mysql/chapter6.html ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 From: SubbaReddy M [EMAIL PROTECTED] To: Charitha [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 3:42 PM Subject: Re: How to get connected with mysql using perl scripts Hi, Check the following links: http://dbi.symbolstone.org/ http://www.saturn5.com/~jwb/dbi-examples.html http://www.oreilly.com/catalog/perldbi/ Best of luck. ~ SubbaReddy .M E-mail: [EMAIL PROTECTED] W3Page: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message - From: Charitha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 1:51 PM Subject: How to get connected with mysql using perl scripts Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - 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
unable to run the mysql server on Start up on Solaris?
Hello Gurus, I have installed the mysql-3.22 on Solaris(Intel) and when I execute the bin/safe_mysqld --user=mysql and support-files/mysql.server start successfully, runing the server and able to enter in mysql client. So, hold on startup as per support-files/mysql.server script document mysql.server file is copied into /etc/init.d and created link file in /etc/rc3.d/S99mysql and restarted system, but not find running the mysql server at start up. So, I manually invoked the support-files/mysql.server start and then working with. Please, sugest me to run at start up. Thanks in advance and wish you happy Christmas and happy new year 2002 for all. ~ SubbaReddy .M - 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
Amazing, zero length files in mysql install kit !!
Hello mysql team, I have downloaded the following mysql kit to install on Solaris (intel) and gtar-i386.gz http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t ar.gz http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz and then done gzip -cd mysql-3.23.39-pc-solaris2.8-i386.tar.gz |gtar-i386 xvf - great, got unziped files. And then tried to install % scripts/mysql_install_db % Nothing got. Then tried to run % mysql just core dump. So, check the file ls -l scripts/mysql_install_db great, 0 (zero) length file. Similarly, in support-files/mysql.server file also 0 (zero) length file. Please, update the kit. So, now i am continuening with mysql-3.22 on solaris. it's working fine. With regards, ~ SubbaReddy .M - 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
Amazing, zero length files in mysql install kit !!
Hello Gurus, I have downloaded the following mysql kit to install on Solaris (intel) and gtar-i386.gz http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t ar.gz http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz and then done gzip -cd mysql-3.23.39-pc-solaris2.8-i386.tar.gz |gtar-i386 xvf - great, got unziped files. And then tried to install % scripts/mysql_install_db % Nothing got. Then tried to run % mysql just core dump. So, check the file ls -l scripts/mysql_install_db great, 0 (zero) length file. Similarly, in support-files/mysql.server file also 0 (zero) length file. Please, update the kit. So, now i am continuening with mysql-3.22 on solaris. it's working fine. With regards, ~ SubbaReddy .M - 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
unable to run the mysql server on Start up on Solaris?
Hello Gurus, I have installed the mysql-3.22 on Solaris(Intel) and when I execute the bin/safe_mysqld --user=mysql and support-files/mysql.server start successfully, runing the server and able to enter in mysql client. So, hold on startup as per support-files/mysql.server script document mysql.server file is copied into /etc/init.d and created link file in /etc/rc3.d/S99mysql and restarted system, but not find running the mysql server at start up. So, I manually invoked the support-files/mysql.server start and then working with. Please, sugest me to run at start up. Thanks in advance and wish you happy Christmas and happy new year 2002 for all. ~ SubbaReddy .M - 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