Am 30.11.2012 23:52, schrieb Rick James:
> Possible causes:
> * Someone is writing to the Slave
that is why the option "read-only" exists for my.cnf
> * The Slave was not in synch with the Master.
> * Schemas are different between Master and Slave
should not happen if the slave is properly clo
Possible causes:
* Someone is writing to the Slave.
* The Slave was not in synch with the Master.
* Schemas are different between Master and Slave.
* Someone is changing the POS for replication.
After you have eliminated those possibilities, provide
SHOW SLAVE STATUS \G
SHOW MASTER STATUS;
SHOW CR
I am trying to set up mysql replication on 2 systems but Once I get it
going, I get the following an error 1062,
which is a duplicate entry and my 'slave status' shows:
Slave_IO_Running: Yes
Slave_SQL_Running: No
And this is the error on my mysql.err file:
121130 12:41:53 [Note
perhaps you are looking for something like
select entry,timestamp from table A where A.timestamp=(select max(B.timestamp)
from table B where a.entry=b.entry);
also this oage may be helpful:
http://www.artfulsoftware.com/infotree/queries.php
re,
wh
Am 30.11.2012 02:39, schrieb h...@tbbs.net:
and answered many times on forums.mysql.com
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Thursday, November 29, 2012 5:40 PM
> To: mysql@lists.mysql.com
> Subject: Re: Retrieve the values from the table of its max date
>
> 2012/11/29 11:46 +0530, Trimurth
I have three tables, TableA, TableB, and TableC each has a unique ID
field, idA, idB, idC respectively each table also has a field called
'Status'. The id field is always greater than zero. Now suppose I have
three variables A, B, and C. Two of them are zero and the other is a
valid ID for
2012/11/29 11:46 +0530, Trimurthy
i have a table which contains the columns
date,sname,age,item,quantity,units.my question is i want to retrieve all
the values from the table where date=maxdate group by sname how can i get
those values.
A question, I suspect, found in all SQL
