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

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 PROT

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 li

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 ||

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 s

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' | +---+

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.m

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]

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:

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]

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/[EMAI

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: De

Largest OLTP on MySQL?

Who has the world's largest OLTP running on MySQL? Appreciate URL containing details. Thanks. Hassan

Efficient SQL Statement

Hi All, Which one of the following statements is more efficient? SELECT * FROM COUNTRY WHERE LEFT(CNNAME,1)='B'; Or SELECT * FROM COUNTRY WHERE CNNAME LIKE 'B%'; Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

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

ibdata1

Hi, How do I resize (shrink & expand) InnoDB file? 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 pr

Validate date

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

: 4406 Enjoy! Hassan Shaikh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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_I

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 AUTO_INCREMENT = ; Any suggestions for InnoDB? Thanks. Hassan

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

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 hostin

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,

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

ERP / Accounting

Hi, Could anyone please provide a list of established ERP/Accounting software based on MySQL? I know about SAP so that doesn't count. ACCPAC, now part of sage.co.uk, is offering on Linux but they don't use MySQL. TIA. Hassan Shaikh

Resetting Auto_Increment

Hi, How do I reset the RTID to the last-highest-number? +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---

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 unsubscrib