thanks
On Wed, Aug 18, 2010 at 10:42 PM, a.sm...@ukgrid.net wrote:
Quoting Norman Khine nor...@khine.net:
What is shown from show master status and show slave status after you
have made a change on the master DB?
this is the output:
http://pastie.org/1100610
it does not seem to have
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
jitendra_ran...@yahoo.comwrote:
Hi,
Whenever i run any commnd on mysql it gives message as below then gives the
result successfully. What is the reason of the
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,
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
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.
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
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;
union
select a.id,b.id from tbl
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
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,
-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 similar
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,
whereby
each
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
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
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 quite
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
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
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, based-on:
If
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
There are so many versions of 5.1, Is there some review or recommendations for
a stable one? thanks
19 matches
Mail list logo