MySQL Query Browser
The MySQL Query Browser online documentation clearly mentions that it runs on 32-bit Windows operating systems, including Windows 95, 98 and Me. However, while installing it on WinME, I get the following error: The Operating System is not adequate for running MySQL Query Browser 1.1 Can anyone please explain? Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1.7 on Windows ME
Hi, How do I install MySQL 4.1.7 on Windows Millenium so that it start automatically on startup? mysqld --install ... does not work on Win9x setups. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Audit Checklist/Program
Hi, Is there any recommended MySQL Auditing guideline available somewhere on the Net? (Anything other then the recommededation mention in the official documentation). If there's any IT Auditor out there who would like to share his/her work? Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Patches
Where can I download patches for MySQL 4.0.17 from? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Concat. operator ||
Hi Paul, Using the following fixed things. However, I am surprised at why it is not working in 4.0.18 (Win32)? Previously I had 4.0.17 (Win32) and things work perfectly. I guess you are right, it's a bug. [mysqld] sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY transaction-isolation=SERIALIZABLE Thanks. Hassan Paul DuBois wrote: At 12:50 -0600 2/23/04, Paul DuBois wrote: At 15:59 +0200 2/23/04, Victoria Reznichenko wrote: Hassan Shaikh [EMAIL PROTECTED] wrote: I am running MySQL in ANSI standard mode. However the following statement is giving unexpected result. Am I missing something? mysql select 'This is a' || ' test string'; +---+ | 'This is a' || ' test string' | +---+ | 0 | +---+ 1 row in set (0.00 sec) Here's a part of my my.ini, indicating that I am in ANSI mode. # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= sql-mode=ansi This should work, but when I try it, it doesn't work. (The sql_mode variable is set to 4, which is the numeric equivalent of the ANSI_QUOTES option. I believe what's happening is that there is an attempt to match prefixes of option names that is done incorrectly.) I'll file a bug report. In the meantime, you can use this instead: [mysqld] ansi Oops, sql-mod=ansi not working isn't a bug after all, at least not if you're using MySQL 4.x. The ansi shortcut was added in 4.1.1: http://www.mysql.com/doc/en/Server_SQL_mode.html That should produce the desired effect. set-variable= key_buffer=32M set-variable= max_allowed_packet=1M set-variable= table_cache=32 set-variable= net_buffer_length=8K set-variable= sort_buffer=1M set-variable= record_buffer=512K set-variable= myisam_sort_buffer_size=4M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 log-bin server-id= 1 What version of MySQL do you use? If you use version 4.1 , you should put in the my.cnf [mysqld] ansi ... or [musqld] sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY transaction-isolation=SERIALIZABLE .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Concat. operator ||
Hi All, I am running MySQL in ANSI standard mode. However the following statement is giving unexpected result. Am I missing something? mysql select 'This is a' || ' test string'; +---+ | 'This is a' || ' test string' | +---+ | 0 | +---+ 1 row in set (0.00 sec) Here's a part of my my.ini, indicating that I am in ANSI mode. # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= sql-mode=ansi set-variable= key_buffer=32M set-variable= max_allowed_packet=1M set-variable= table_cache=32 set-variable= net_buffer_length=8K set-variable= sort_buffer=1M set-variable= record_buffer=512K set-variable= myisam_sort_buffer_size=4M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 log-bin server-id= 1 Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyISAM Table Corruption
What are the chances of MyISAM tables corruption when the table is update rarely? (Once in a 60+ days). It's basically a lookup table used mainly in SELECT statements. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FULLTEXT Index under InnoDB
Is there any plan to introduce FULLTEXT indices under InnoDB table types? Regards, Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AES_ENCRYPT returned value
Hi, What's the best data type to store AES_ENCRYPTed text/password (without any data conversion)? I believe it can't be stored in CHAR or VARCHAR due to implicit internal conversions. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AUTO_INCREMENT in InnoDB
I can't drop the table. Can't I do without dropping the table? Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AUTO_INCREMENT in InnoDB
Hi, How do I reset the AUTO_INCREMENT column to some arbitrary number? My table type is InnoDB. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.cnf on Shared Hosting
Hi, I want --ansi option for MySQL setting to ensure ANSI compatibility. Most shared hosting providers don't allow access to my.cnf. Is there anyway to do this on the fly in my script, PHP/Perl sample would be appreciated. Thanks. Hassan
Resetting auto_increment field in an INNODB table
Hi, How do I reset an AUTO_INCREMENT column? My table type is InnoDB and the method mentioned in the manual is not applicable. I am using MySQL 4.0.17. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Customized auto-increment serial number
Hi, I've a unique requirement where the transaction number should be automatically generated (increment). I can't use AUTO_INCREMENT column. The TRAN_NO is supposed to be in MF format, where: Field: TRAN_NO CHAR(10) M = Encoded current month (A: January, B: February, C: March . L: December) = Current year (e.g. 2004, 2005, ...) F = Running serial number in hexadecimal format (so the smallest number is 1 and the largest number would be F; the serial number will reset to 1 at the beginning of each month) How can I generate this number using MySQL without running into concurrency problem? Also, this is a web-based app and I am planning to use PHP for coding. My production environment is MySQL 4.0.17 on Linux. Development platform is Windows XP with MySQL 4.0.17. TIA. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Largest OLTP on MySQL?
Who has the world's largest OLTP running on MySQL? Appreciate URL containing details. Thanks. Hassan
DB Designer 4
Hi, I've learned from fabFORCE.net that DB Designer 4 is bought by MySQL AB. Could any one from MySQL AB please comment on the new acquisition and shed some light on integration plans with MySQLCC? Thanks. Hassan
Euro Symbol ()
Hi, I've inserted the following currecy sumbols in my table (structure mentioned below). All symbols are displayed properly when I do select, expect for the Euro symbol, which just shows a question mark (?). Any idea why is it behaving like that? I am using MySQL 4.0.17 on Windows XP Pro. My production server is Linux based. Euro Yen Pound Sterling $Dollar +--++--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--++--+-+-+---+ | CYRANK | decimal(3,0) unsigned zerofill | | | 999 | | | CYSYMBOL | varchar(5) | YES | | | | | CYNAME | varchar(50)| | | | | | CYCODE | char(3)| | PRI | | | +--++--+-+-+---+ Thanks. Hassan
ibdata1
Hi, How do I resize (shrink expand) InnoDB file? Thanks. Hassan
Validate date
Quote from MySQL documentation ... MySQL allows you to store some wrong date values into DATE and DATETIME columns (like 2000-02-31 or 2000-02-00). The idea is that it's not the SQL server job to validate date. If MySQL can store a date and retrieve exactly the same date, then MySQL will store the date. If the date is totally wrong (outside the server's ability to store it), then the special date value -00-00 will be stored in the column. IMHO, it is the database job to ensure that date/time is valid as it's stored. Hassan Shaikh
Live MySQL database
To those who want to try out a live MySQL on the Net can use the following from NAVICAT. You can choose client tool of your choice! Get more information about it on NAVICAT website: www.navicat.com IP/Server: server1.navicat.com User: navicat Password:navicatdemo Port: 4406 Enjoy! Hassan Shaikh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which one is better: CHAR or VARCHAR?
Hi, I've a column of type VARCHAR(10) where I know the data would be 10-char in length - always. Apart from the fact that VARCHAR saves space as compared to CHAR, is there any performance benefit? If yes, is it significant enough? Thanks. Hassan
Resetting Auto_Increment
Hi, The following does not work for InnoDB tables. The manual says The next AUTO_INCREMENT value you want to set for your table (MyISAM). ALTER TABLE table_name AUTO_INCREMENT = new_value; Any suggestions for InnoDB? Thanks. Hassan
Re: Resetting Auto_Increment
You got to be kidding! I am sure there's a better solution. Hassan - Original Message - From: Tobias Asplund [EMAIL PROTECTED] To: Hassan Shaikh [EMAIL PROTECTED] Cc: Sent: Monday, January 12, 2004 9:43 PM Subject: Re: Resetting Auto_Increment On Mon, 12 Jan 2004, Hassan Shaikh wrote: Hi, The following does not work for InnoDB tables. The manual says The next AUTO_INCREMENT value you want to set for your table (MyISAM). ALTER TABLE table_name AUTO_INCREMENT = new_value; Any suggestions for InnoDB? Insert a row with a custom value, then delete it, the next value insrted will be value+1 of the value you juse inserted. Example below: [EMAIL PROTECTED]:tmp CREATE TABLE ai (num INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARy KEY) TYPE=INNODB; Query OK, 0 rows affected (0.01 sec) [EMAIL PROTECTED]:tmp INSERT INTO ai VALUES (NULL), (NULL), (NULL); Query OK, 3 rows affected (0.02 sec) Records: 3 Duplicates: 0 Warnings: 0 [EMAIL PROTECTED]:tmp SELECT * FROM ai; +-+ | num | +-+ | 1 | | 2 | | 3 | +-+ 3 rows in set (0.00 sec) [EMAIL PROTECTED]:tmp INSERT INTO ai VALUES(10); Query OK, 1 row affected (0.00 sec) [EMAIL PROTECTED]:tmp DELETE FROM ai WHERE num=10; Query OK, 1 row affected (0.01 sec) [EMAIL PROTECTED]:tmp INSERT INTO ai VALUES(NULL); Query OK, 1 row affected (0.00 sec) [EMAIL PROTECTED]:tmp SELECT * FROM ai; +-+ | num | +-+ | 1 | | 2 | | 3 | | 11 | +-+ 4 rows in set (0.00 sec) [EMAIL PROTECTED]:tmp \t --- avast! Antivirus: Inbound message clean. Virus Database (VPS): 1/8/2004 Tested on: 1/12/2004 11:26:18 PM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Automatic conversion from `char` TO `varchar`
Hi, It's really strange but when I execute the following statement, all my char(10) columns turn into varchar(10). My other tables are ok and I've tried create dummy table also. Problem seems to be associated with this table only. CREATE TABLE `offer` ( `SVID` int(11) NOT NULL auto_increment, `CUID` char(10) NOT NULL default '', `OFTXT` text, `OFAMOUNT` decimal(12,2) NOT NULL default '0.00', `OFTYPE` char(1) NOT NULL default 'P', `OFSENTDT` datetime default NULL, `OFREPLYDT` datetime default NULL, `OFREPLYTXT` text, `OFRESULT` char(1) NOT NULL default 'X', `PID` char(10) NOT NULL default '', PRIMARY KEY (`SVID`) ) TYPE=InnoDB ; Would appreciate if someone could provide some insight. Thanks. Hassan
DST
Gentlemen, Thank you for your informative coverage regarding the captioned. According to your recommendations I've created a separate location table which contains time zone difference in (+/-) minutes. As per the server, my assumptions is that it's located somewhere in California, U.S. (my hosting provider is using EV1). My question is, how to write bulletproof code so that my server code (in PHP) would always store date/time in GMT? Also, how do I tackle DST, and automatically adjust incoming time for daylight saving changes. Appreciate your input and help. Thanks! Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Time Zone
Hi, How do I change datetime from one time zone to another? I've a column in one of my tables having the type DATETIME and I need to show date AND time to end-user based on his/her preference. TIA. Hassan
GUID
Hi, How do I generate a GUID (Globally Unique Identifier) under MySQL on Linux. I am doing it under Win32 using one of the documented Win32 API but I want to do it on a Linux platform? Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Resetting Auto_Increment
Hi, How do I reset the RTID to the last-highest-number? +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | RTLUPDATE | timestamp(14)| YES | | NULL|| | RTDESC| varchar(30) | | | || | RTID | tinyint(3) unsigned zerofill | | PRI | NULL| auto_increment | +---+--+--+-+-++ Thanks. Hassan