Date range with empty rows (Was: Intra-table join)

2004-10-13 Thread Partap Davis
On Wed, 13 Oct 2004 20:25:48 -0700, Chris <[EMAIL PROTECTED]> wrote: >> create table test_table >> (d date not null, >> name char(32) not null, >> loc integer not null, >> type integer not null, >> amount integer, >> primary key (d, name, loc, type)); snip snip > This is how

Re: relay log hosed

2003-10-07 Thread Partap Davis
info to continue at the point of failure? (assuming the disk is not bad and the data is valid...which it seems to be so far) Thanks, Partap Davis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

relay log hosed

2003-10-07 Thread Partap Davis
nt of failure? (assuming the disk is not bad and the data is valid...which it seems to be so far) Thanks, Partap Davis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL crash (replication?)

2003-10-02 Thread Partap Davis
Hi folks, I just set up a slave server and it seemed to be working alright, catching up with the new data, and then the server suddenly went away. Looking at the slave's data directory, there are approximately 2 relay-bin files. I can't even restart the server now, because it gets a sig

Join using temporary, filesort

2003-07-17 Thread Partap Davis
I asked this a couple days ago, but never got an answer, so I'll try to include some more detail: MySQL 4.0.12 on linux 2.4.18... I'm doing a join on 2 tables and trying to optimize it but I always end up with "Using temporary; Using filesort" and the query takes way too long... What can I do to

Re: How can I display images from a mySQL Database in a web page?

2003-07-15 Thread Partap Davis
I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? First you would need to encode it in some ascii equivalent (check w3c.org, I think) ...and it would increase the size of your html page while rendering the browser's image cache