Re: Help with mysql query, multiple list

then either build the statement by way of a program like a perl script or select all records with a start time after the min start time of all in your list and an end time less than the max end time in your list then filter them further either in a program or a store procedure. On Fri, May 8, 2009

Re: Help with mysql query, multiple list

Abhi, I might not be understanding the problem but could you use the max and min timestamp values and use something like SELECT * FROM TABLE WHERE start BETWEEN max AND min AND end BETWEEN max AND min or SELECT * FROM TABLE WHERE START IN (1,2,3,4,5) AND END IN(1,2,3,4,5) I might be complet

Re: Unix compress equivalent

Or even better, can I tell load data infile or somewhere in the table definition to compress whatever is written to the file? Thanks Olaf On 5/8/09 12:29 PM, "Olaf Stein" wrote: > Hi all > > What is the equivalent in unix (more specifically python) to the compress() > function. > > I am tryi

Re: Help with mysql query, multiple list

Hi Jim Unfortunately I have thousands of such points. So explicit statement calling will be very expensive both computationally and in terms of writing.. Thanks, -Abhi On Fri, May 8, 2009 at 12:37 PM, Jim Lyons wrote: > why not something like below. Assume you have 3 pairs of start/end > time

Re: Help with mysql query, multiple list

why not something like below. Assume you have 3 pairs of start/end timestamps and you want to find everything within those 3 time periods: select * from table_name where start >= start1 and end <= end1 union select * from table_name where start >= start2 and end <= end2 union select * from table_

Re: Help with mysql query, multiple list

aah okie I think I was trying to get too clever. Guess that won't work ... Thanks, -Abhi On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert wrote: > You'll have to iterate over your two lists of timestamps and build a > set of ORed conditional pairs: > > sql = "select ... from ... where 1 = 0" > f

Unix compress equivalent

Hi all What is the equivalent in unix (more specifically python) to the compress() function. I am trying to make csv file for use with load data infile and am wondering how to compress the strings that I would usually compress with compress() in a regular sql statement. The field I am writing thi

Help with mysql query, multiple list

Hi All I am kind of stuck with this query , cant expand my thinking. May this is a limitation. Here it is I have a database with many cols two of which are start and end position for an event. Now I have a list of event time stamps, I want to find all the info once the current event time stamp

Re: Memory corrupting, while retrive the query generated

Ravi raj schrieb: > Dear walter Harms, > > Thanks for your valuable solution, but in the code which > you provided is printing only one row , if i try to print whole table, > or 2, or 3, columns fully means its giving segmentation fault, kindly > check the below code for furthur in

Re: Memory corrupting, while retrive the query generated

Dear walter Harms, Thanks for your valuable solution, but in the code which you provided is printing only one row , if i try to print whole table, or 2, or 3, columns fully means its giving segmentation fault, kindly check the below code for furthur information. software used:

utf8_bin or utf8_general_ci

Hello, I would like save text (different languages) in a MySQL-Table and I don't know, which Collation is the right one for me. utf8_bin or utf8_general_ci? OK, in utf8_general_ci I know that the Collation is CASE INTENSIVE but it isn't a problem. But what is better for Text in different l

Lock wait timeout error

Here is the table structure. CREATE TABLE `UP_UserEx` ( `UserId` INT(11) NOT NULL, `UserNationality` CHAR(2) NOT NULL DEFAULT '', `UserProvince` CHAR(2) NOT NULL DEFAULT '', `UserCity` CHAR(4) NOT NULL DEFAULT '', `HomePhone` VARCHAR(32) NOT NULL DEFAULT '', `WorkPhone` VARCHAR(32) NOT

reduce number of open files ?

hi list, i am wondering if there is a way to reduce the number of open files. The database has InnoDB and MyISAM. I have a lot a partitions is that a problem ? (To many open files causes problems for mysqldump) running is vanilla 5.1.34 show status like '%open%' ; +--+--

[High]Thread creation error

Hi all, after random times not only about high usage, i have this message on Mysql Administrator ( Windows ), logged to my Dedicated Database ( Linux ). Here is a print of error: http://img25.imageshack.us/img25/2342/mysqlthreaderror.jpg Here is a print of putty using 'top' on dedicated server: ht