InnoDB Commit question

finished. Has anyone else noticed this behavior? What could be causing this? Any help appreciated Rob Brooks The Brian Group LLC

Commit question

is finished. Has anyone else noticed this behavior? What could be causing this? Any help appreciated Rob Brooks The Brian Group LLC

RE: Query Error Help

nm ... I found the problem ... I need to use BINARY(LPAD ...) -Original Message- From: Rob Brooks [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 10:04 AM To: mysql@lists.mysql.com Subject: Query Error Help Hello, I have this query: SELECT FL3_PatientControlNumber

Query Error Help

Hello, I have this query: SELECT FL3_PatientControlNumber, claims.RecordKey as reckey, FL1_ProviderName, CalcFlag FROM claims INNER JOIN service_line ON service_line.ClaimKey = claims.RecordKey WHERE ( service_line.FL42_ServiceLineRevCode BETWEEN LPAD('110',4,'0') AND LPAD('210',4,'0' ) ) OR

RE: Anyone use Snort and Acid?

I used snort and acid but that go me nowhere -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Monday, November 14, 2005 11:18 PM To: mysql@lists.mysql.com; Ed Kasky Subject: Re: Anyone use Snort and Acid? > . . . . . . . . . . . . . . . . . . > Randomly Generated Quote (12

max packet size question

Is there a practical maximum for max packet size? Is it simply a function of the amount of memory that you have?

server params

Hello, we have a web based application where the mysql server runs on a separate box from the code. The 2 boxes are on the same subnet so there really shouldn't be any latency issues(emphasis on shouldn't .) but we're trying to track down some timeout glitches in the application. I was wondering

wait_timeout

I have the following in the mysqld section of my.cnf: set-variable = wait_timeout=360 everything else in the conf file seems to take but my wait_timeout variable stays at the default of 28800 my version is 4.0.20 for apple-darwin6.8 Any thoughts?

FW: need opinion on FmPro Migrator

The tool is well regarded. I have not used it, but many people have with success. But, most FMP databases are so poorly structured that it is often best to start over. Keep in mind the necessity of importing data from FMP to MySQL though. . Kevin Bice Foster Ent

table join question

Although I didn't find it in the docs anywhere, I know from experience that you cannot join more than 31 tables in 4.0.21 I was wondering if anybody knew if this limit has changed in version 5 Thx Rob

number of table joins in MySQL 5.xx

Is the maximum number of table joins still 31 in MySQL 5.xx?

RE: using between

Well, we have this db with various ip address ranges and the country of origin associated with each ... the format is: countryOfOrigin FromIP ToIP --- -- US some lower boundsome upper bound Canada

using between

Hello Is there a way when searching for a range of values for a particular field that mysql would not have to look at the entire table ... I'm guessing with some type of composite key or something? ... e.g. SELECT aField FROM aDatabase WHERE aVariable BETWEEN field1 AND field2; Field1 and field

RE: SQL help

in question below, the problem is not in record '7047' but in the record which starts with the name 'Triad' also ... I'm using 4.0.20-standard-log -Original Message- From: Rob Brooks [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 2:56 PM To: mysq

SQL help

Can someone help me with this? this statement: select Items.Name, Items.Detail, Items.ID, items_online.ID from Items left join items_online on items_online.ItemKey = Items.ID where (Name regexp 'ad') and AccountKey = 108 and Items.Active = 1; gives this: +---+--

group_concat

Hello, I have a strong need/desire to use group_concat but I don't/can't run 4.1 right now. There is MyGroupConcat http://www.codeproject.com/useritems/MyGroupConcat.asp And I have no problem creating a .so on FreeBSD but I have a server running OSX and I'm not familiar with shared code on thi