On 9/6/2010 9:10 AM, Thorsten Heymann wrote:
No, I think you misunderstood me. I have these keys (in this example)
- PRIMARY (id)
- UNIQUE (ip_addr)
- UNIQUE (print_name)
And when of of the UNIQUEs is duplicated, I'll wshow user a message WHAT key is
a doublette.
Hi Thorsten, all!
Thorsten Heymann wrote:
> Hi,
>
> First, I'm new to this mailing list, hopefully I'll do my post the *right*
> way.
>
> I've a problem with duplicate key error messages. In my application I use a
> table with multiple unique keys (ip_addr and print_name). Lets use this
> ex
Hi List,
In a 20m interval in our max load I have:
OS WAIT ARRAY INFO: reservation count 637, signal count 625
Mutex spin waits 0, rounds 19457, OS waits 428
RW-shared spins 238, OS waits 119; RW-excl spins 13, OS waits 8
(The values are the difference between the start and end of this 20m
inter
Thanks for your great response Travis. This is exactly what I was after.
On Thu, Aug 26, 2010 at 6:56 PM, Travis Ard wrote:
> I don't think there's anything inherently wrong with the way you've
> designed
> your table to store your match data. I don't have experience designing
> these kinds of
No, I think you misunderstood me. I have these keys (in this example)
- PRIMARY (id)
- UNIQUE (ip_addr)
- UNIQUE (print_name)
And when of of the UNIQUEs is duplicated, I'll wshow user a message WHAT key is
a doublette.
Von: Tompkins Neil [mailto:neil.tompk...@googl
Not the answer I hoped to get but, thanks Carsten!
-Ursprüngliche Nachricht-
Von: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Gesendet: Montag, 6. September 2010 15:17
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
On Mon, 6 Sep 2010 15:02:24 +0200,
On Mon, 6 Sep 2010 15:02:24 +0200, Thorsten Heymann
wrote:
> Digging through mysqld source, I found this behaviour handled in
> sql/handler.cc and changed from printing key_nr to key.name between this
> versions. :(
>
> Is there a possible better, reliable way to detect what key is
duplictated
>
Hi
You have a PRIMARY KEY of just the id field like PRIMARY KEY ( `id` ). You
need both ip and type to be the primary key
Cheers
Neil
On Mon, Sep 6, 2010 at 2:02 PM, Thorsten Heymann wrote:
> Hi,
>
> First, I'm new to this mailing list, hopefully I'll do my post the *right*
> way.
>
> I've a p
Hi,
First, I'm new to this mailing list, hopefully I'll do my post the *right* way.
I've a problem with duplicate key error messages. In my application I use a
table with multiple unique keys (ip_addr and print_name). Lets use this example:
Table `device` :
CREATE TABLE `device` (
`id` INT NOT
For sure here is some sample data
home_teams_id,away_teams_id,home_goals,away_goals,home_users_id,away_users_id
100,200,2,1,5,6
200,100,1,1,6,5
Here is two rows of data for the same fixture both home and away
Let me know if you need any more info.
Cheers
Neil
On Mon, Sep 6, 2010 at 1:08 PM,
Also, can u please lets u know the value's in this table.
Just one row, an example would do.
regards
anandkl
On Mon, Sep 6, 2010 at 5:35 PM, Tompkins Neil
wrote:
> These two fields
>
> home_goals and away_goals
>
> Cheers
> Neil
>
>
> On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar wrote:
>
>>
These two fields
home_goals and away_goals
Cheers
Neil
On Mon, Sep 6, 2010 at 12:58 PM, Ananda Kumar wrote:
> Tompkins,
> Which field stores the result of matches.
>
> regards
> anandkl
>
> On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil <
> neil.tompk...@googlemail.com> wrote:
>
>> Hi,
>>
>> I
Tompkins,
Which field stores the result of matches.
regards
anandkl
On Mon, Sep 6, 2010 at 4:45 PM, Tompkins Neil
wrote:
> Hi,
>
> I've the following fields within a table :
>
> fixtures_results_id
> home_teams_id
> away_teams_id
> home_goals
> away_goals
> home_users_id
> away_users_id
>
> From
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), "Robert P. J. Day"
wrote:
> no, i don't want to start a flame war, i just want some feedback on
> a current list of mysql "drawbacks" WRT postgresql.
>
> in the context of a fully open-source, java based ECM product, there
> is a FAQ entry that summarize
Hi,
I've the following fields within a table :
fixtures_results_id
home_teams_id
away_teams_id
home_goals
away_goals
home_users_id
away_users_id
>From this I want to extract the following type of information if
the home_users_id or away_users_id = 1 :
total number of games games
number of games
no, i don't want to start a flame war, i just want some feedback on
a current list of mysql "drawbacks" WRT postgresql.
in the context of a fully open-source, java based ECM product, there
is a FAQ entry that summarizes why the developers would prefer their
users to use postgresql as opposed
Hi,
We're chaning it to INT(9). Apparently someone remembered to change the type
of data in this field from an alphanumeric value to an INT(9).
I'm going to change this asap.
Thanks
BR
AJ
On Mon, Sep 6, 2010 at 5:17 AM, mos wrote:
> At 04:44 AM 9/3/2010, Alexandre Vieira wrote:
>
>> Hi Johnn
Just another quick question - following my initial question regarding the
best method to keep totals, I wondered if I should adopt a table to record
team league standings like based on each result like
team_id
home_win
home_draw
home_loss
home_goals
home_conceded
away_win
away_draw
away_loss
away_
No it does not. But when I dump database name "mydb" it does. but not
the database with name "1".
--
Regards,
Manasi Save
On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote:
On 06/09/2010 6:54 a, Manasi Save wrote:
> > Dear Nitin,
> >
> > I have newly installed mysql on this server.
> >
On 03/09/2010 9:26 p, Hank wrote:
On Fri, Sep 3, 2010 at 6:23 AM, Jangita wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried "running away from the problem :-)" by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT * FROM table1 WHER
On 03/09/2010 9:27 p, Hank wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried "running away from the problem :-)" by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT * FROM table1 WHERE id = theid)
UNION
(SELECT * FRO
On 06/09/2010 6:54 a, Manasi Save wrote:
Dear Nitin,
I have newly installed mysql on this server.
mysql> Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same
22 matches
Mail list logo