Re: MySQL Server has gone away

Hi Jitendra, Check your error log file. Some thing might have gone wrong. Krishna On Wed, Aug 18, 2010 at 9:41 PM, jitendra ranjan wrote: > Hi, > > Whenever i run any commnd on mysql it gives message as below then gives the > result successfully. What is the reason of the below error message :

Re: MySQL Server has gone away

there is high chance of corruption of any data files, but it will clear only after looking of your error file (generated by mysql) can you post the 50 last lines of your mysql error file. On Thu, Aug 19, 2010 at 4:35 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Jitendra, >

Re: OpenOffice, Go-OO, ODBC, Offline Data Entry

Hi! Jerry Schwartz wrote: > I deal with a somewhat similar situation. Even though we have fast VPN > connections among our various offices, each has been afflicted with a > different database structure (and software) which they cannot change. > > What I suggest you do is use the kind of "pseud

Workbench strange behavior

Hi ALL, I just start using Workbench 5.2.26 CE and this is a problem I have. When I try to run a query with a case statement, columns with datetime Type shown as "BLOB" in output window. To see the output data I have to right click inside of the cell, choose "Open Value in Viewer" and see text. Exa

Fixture List generation using MySQL

Hi, I'm tasked with generating a list of fixtures from a table of teams, whereby each team plays each other home and away. Does anyone have any experience generating such information using MySQL ? Thanks for any input. Regards Neil

Re: Fixture List generation using MySQL

I'm tasked with generating a list of fixtures from a table of teams, whereby each team plays each other home and away. Does anyone have any experience generating such information using MySQL ? Basically ... select a.id,b.id from tbl a join tbl b on a.idb.id; PB - On 8/19/2010 9:12 AM

Re: MySQL Server has gone away

Here is few lines from log:   100703 22:12:48 mysqld ended 100703 22:23:39 mysqld started 100703 22:23:40 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 100703 22:23:40 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to

Re: RHEL Auto Start / stop mysql???

In case you have not already discovered it, the clue you need is the ` chkconfig --level 345 mysql on` shell command mentioned in that web page. In your system it is not enough to have a script in /etc/rc.d/init.d/, you also need links in your /etc/rc.d/rc{runlevel}.d/ directories. Regards, Mike

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

>-Original Message- >From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] >Sent: Thursday, August 19, 2010 7:25 AM >To: mysql@lists.mysql.com >Cc: Jerry Schwartz; 'Lord_Devi' >Subject: Re: OpenOffice, Go-OO, ODBC, Offline Data Entry > >Hi! > > >Jerry Schwartz wrote: >> I deal with a somewhat

Re: Fixture List generation using MySQL

I'm looking at a routine / script to create the fixtures like team 1 vs team 2 team 3 vs team 4 team 5 vs team 6 etc > > > > On Thu, Aug 19, 2010 at 3:44 PM, Peter Brawley < > peter.braw...@earthlink.net> wrote: > >> >> >> I'm tasked with generating a list of fixtures from a table of teams, >>>

Re: Fixture List generation using MySQL

I'm looking at a routine / script to create the fixtures like team 1 vs team 2 team 3 vs team 4 team 5 vs team 6 etc Build the script round the query. PB - On 8/19/2010 12:07 PM, Tompkins Neil wrote: I'm looking at a routine / script to create the fixtures like team 1 vs team 2 te

RE: Fixture List generation using MySQL

That's almost a cartesean product; except you just want to eliminate results where a team would be paired up with itself. > create table teams ( id serial ); Query OK, 0 rows affected (0.02 sec) > insert into teams values (), (), (), (); Query OK, 4 rows affected (0.05 sec) Records: 4 Duplicate

Re: Fixture List generation using MySQL

One possible approach: In your script, generate some ordered iterable object with an index of your team names. Step through it in a loop and check the counter; match "odd" teams with "even" teams and generate your queries. You could probably do this on the server end as well as the logic is quit

Re: Fixture List generation using MySQL

I have written this in both C and Java. It is very complex as, in real life, you want to balance home and away, sequence the games so that the home or away games are spread throughout the schedule, accomodate partial rounds (10 team league where each team is to play 13 games), accomodate odd numb

MySQL Community Server 5.1.50 has been released

Dear MySQL users, MySQL Community Server 5.1.50, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.50 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysq

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

> >> Is this foolproof? Absolutely not, if there are conflicts between the > >> changes > >> by different users. You'll be stuck with "He who write last, writes best"; > >but > >> I think that's as good as it's going to get for you. > > > >AIUI, you could prevent that by having a second timestamp,

Seems like an easy query, but isn't to me. Help?

I hope I've come to right place, and I'm asking in the right way -- please accept my apologies if not. We have some dates missing and I need to populate those fields with dates from the record just before them. I've gotten this far: SELECT UUid, MIN(DDenteredDate) minDate FROM UUtable JOIN DDdet

5.1.x review

There are so many versions of 5.1, Is there some review or recommendations for a stable one? thanks