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 courses
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
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, Trimurthy
i have
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:
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
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
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 cloned