RE: Regarding Connection Context

2004-12-11 Thread lakshmi.narasimharao
Hi, Thanks for your reply. A runtime context, usually simply called a context, is a handle to a an area in client memory which contains zero or more connections, zero or more cursors, their inline options (such as MODE, HOLD_CURSOR, RELEASE_CURSOR, SELECT_ERROR, and so on.) and other

Re: FOREIGN_KEY CHECKS

2004-12-11 Thread Josh Trutwin
On Wed, 8 Dec 2004 08:21:54 +0200 Heikki Tuuri [EMAIL PROTECTED] wrote: dumps do contain that setting in 4.1.7. Below is a start of a dump file. [EMAIL PROTECTED]:~/mysql-4.1/client ./mysqldump test dump [EMAIL PROTECTED]:~/mysql-4.1/client cat dump | more -- MySQL dump 10.9 -- -- Host:

Re: Problems Moving from 3.23 to 4 (Win2k)

2004-12-11 Thread Fredrick Bartlett
Shut down mysql then in your my.cnf add old-passwords directive. Then copy your user tables again from your backup. You should be ok now. Fredrick - Original Message - From: A. Clausen [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, December 10, 2004 3:33 PM

Load Index Into Cache is broken! ... and a workaround

2004-12-11 Thread Philip Lane
Hi, I saw a couple of posts about this and thought I'd join the chorus. Running version 4.1.7 on a WinXP system. I have a table mindata containing just over 1 million lines of price/volume data for exchange-traded stocks. It's for a .NET web application. There are about 3500 different

Strange results

2004-12-11 Thread Steve Grosz
I'm curious, why if I enter this code: select * from vendor left outer join model on vendor.PID=model.VendorID left outer join specs on model.Model=specs.ProdModel where vendor.Vendor='#URL.Vendor#' do I get the results like: http://www.scootervilleusa.com/test1.cfm?Vendor=Tank I simply want 1 row

ORDER BY sorting

2004-12-11 Thread Mike Blezien
Hello, I'm trying to figure out how sort a column alphabetically, but some of the values start with a numerical value. So when I do the ORDER BY column_name all the values starting alphabeticlly are listed first, then the numerical values after that.. can this be done in a single query.. MySQL

Re: Load Index Into Cache is broken! ... and a workaround

2004-12-11 Thread Kevin A. Burton
Dan Nelson wrote: In the last episode (Dec 11), Philip Lane said: I saw a couple of posts about this and thought I'd join the chorus. Running version 4.1.7 on a WinXP system. I have a table mindata containing just over 1 million lines of price/volume data for exchange-traded stocks. It's for

Re: Strange results

2004-12-11 Thread Steve Grosz
If you can tell me the command to dump the table format, I'm more than happy to list it here. Steve Rhino wrote: - Original Message - From: Steve Grosz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 11, 2004 3:57 PM Subject: Strange results I'm curious, why if I

Re: Load Index Into Cache is broken! ... and a workaround

2004-12-11 Thread Dan Nelson
In the last episode (Dec 11), Philip Lane said: I saw a couple of posts about this and thought I'd join the chorus. Running version 4.1.7 on a WinXP system. I have a table mindata containing just over 1 million lines of price/volume data for exchange-traded stocks. It's for a .NET web

Re: Strange results

2004-12-11 Thread Kevin A. Burton
Steve Grosz wrote: If you can tell me the command to dump the table format, I'm more than happy to list it here. SHOW CREATE TABLE FOO; -- Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #rojo if you want to chat. Rojo is Hiring! -

Re: Strange results

2004-12-11 Thread Steve Grosz
Ok, here's the model table: Table,Create Table model,CREATE TABLE `model` ( `PID` tinyint(3) NOT NULL auto_increment, `VendorID` tinyint(4) NOT NULL default '0', `Model` varchar(15) NOT NULL default '', PRIMARY KEY (`PID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 The vendor table:

Re: confirm subscribe to mysql@lists.mysql.com

2004-12-11 Thread Filipe Sousa
On Saturday 11 December 2004 21:28, [EMAIL PROTECTED] wrote: To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please click on the following link: http://lists.mysql.com/s/mysql/41bb668380f64235/natros=gmail.com This confirmation serves two purposes.

MS Server 2003

2004-12-11 Thread Kenny Chamber
I have been using MySQL on MS Server 2000 and happy enough with it. I'm just migrating To MS Server 2003 Enterprise Edition Does any body have an experience of particular problems? --- Kenny Chamber http://gem-hs.org/contact.html -- MySQL General Mailing List For

Re: Strange results

2004-12-11 Thread Rhino
- Original Message - From: Steve Grosz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 11, 2004 3:57 PM Subject: Strange results I'm curious, why if I enter this code: select * from vendor left outer join model on vendor.PID=model.VendorID left outer join specs

Re: Regarding Connection Context

2004-12-11 Thread Shankar Unni
[EMAIL PROTECTED] wrote: A runtime context, usually simply called a context, is a handle to a an area in client memory which contains zero or more connections, zero or more cursors, their inline options (such as MODE, HOLD_CURSOR, RELEASE_CURSOR, SELECT_ERROR, and so on.) and other additional