recursion

2008-02-26 Thread Thufir
I'm reading "SQL for dummies" and one of the more interesting sections was on recursion. The example query was something like: WITH RECURSIVE ReachableFrom (Source, Destination) AS (SELECT Source, Destination FROM FLIGHT UNION SELECT in.Source, out.Destination FROM Reacha

[RFH] Full Text search

2008-02-26 Thread Imran M Yousuf
Dear Users, I am facing a problem related to full text search. I am trying to search non latin characters with no success :(. I am trying the following queries for searching and only the English one works. SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('নাম নাই' in boolean mode) SELECT *

Re: Insert...on duplicate with aggregate

2008-02-26 Thread Baron Schwartz
Hi! On Tue, Feb 26, 2008 at 7:04 PM, Phil <[EMAIL PROTECTED]> wrote: > I have a table countrystats defined as > > CREATE TABLE IF NOT EXISTS `countrystats` ( > `proj` char(6) NOT NULL default '', > `country` char(50) NOT NULL default '', > `score` double default NULL, > `nusers` int(11) d

mysqlmanager on FreeBSD

2008-02-26 Thread Vidal Garza
Hi SO= FreeBSD 6.3 Ports Instalation. Version 5.0.51a Im install mysql but mysqlmanager dont exist and mysql_multi to. I update the Makefile with option. --with-mysqlmanager But doesnt work, it doesnt appear. I dont understand whats going on. -- ==

Insert...on duplicate with aggregate

2008-02-26 Thread Phil
I have a table countrystats defined as CREATE TABLE IF NOT EXISTS `countrystats` ( `proj` char(6) NOT NULL default '', `country` char(50) NOT NULL default '', `score` double default NULL, `nusers` int(11) default NULL, `RAC` double default NULL, `last_update` double default NULL, PRI

Re: Apache log errors

2008-02-26 Thread Michael Dykman
> My web server log error is " NULL::dba can't connect to mysql" > > The above error shows occasionally in the error log file of apache. Every > thing is fine on the mysql database server. It happens twice or thrice a > day. I am not able to find out whats the issue. > If you aren't observing

MySQL University session on February 28

2008-02-26 Thread Stefan Hinz
Hi, this Thursday, Sergey Petrunia will give a MySQL University session: http://forge.mysql.com/wiki/New_Optimizer_Features_in_MySQL_6.0 Please register for this session by filling in your name on the session Wiki page. Registering is not required but appreciated. That Wiki page also contains a

RE: Apache log errors

2008-02-26 Thread Lawson Cronlund
Chandra, I had to deal with what might be the same problem with a MYSQL installation. I found that MYSQL has a built-in protection against "orphaned" connections. It closes a connection after 8 hours of no activity. My solution was to make an access to the database about every 4 hours from my app

RE: Select form a list

2008-02-26 Thread Edward Kay
> i have list where I would like make a select, this list look like this > > id Properties Others > * > 11 sss > 22 sss > 32 a etc... > 42 > 52 > 61 > 72 > 82 > 9

Select form a list

2008-02-26 Thread Pau Marc Munoz Torres
Hi i have list where I would like make a select, this list look like this id Properties Others * 11 sss 22 sss 32 a etc... 42 52 61 72 82 91 .. imagine

Re: [EMAIL PROTECTED] Apache log errors

2008-02-26 Thread Krishna Chandra Prajapati
Perl is being used for scripting On Tue, Feb 26, 2008 at 3:44 PM, Vincent Bray <[EMAIL PROTECTED]> wrote: > On 26/02/2008, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > My web server log error is " NULL::dba can't connect to mysql" > > This isn't an apache error; at a guess, it's proba