2011/10/24 16:31 -0700, Daevid Vincent
WHERE cs.customer_id = 7
GROUP BY customer_id
Well, the latter line is now redundant.
How will you make the '7' into a parameter?
--
MySQL General Mailing List
For list archives:
` (
`subscription_id` bigint(12) unsigned NOT NULL default '0',
`customer_id` int(10) unsigned NOT NULL default '0',
`date` date NOT NULL default '-00-00',
...
);
I want to show a table where I list out the ID, email, username, and LAST
SUBSCRIPTION.
I need this data in TWO ways
-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Monday, October 24, 2011 1:46 PM
To: mysql@lists.mysql.com
Subject: Within-group aggregate query help please - customers and latest
subscription row
I know this is a common problem, and I've been struggling with it for a
full
day now but I
Okay, it seems I am learning... slowly...
So there needs to be a second WHERE in the sub-select...
To get ONE customer's last subscription (0.038s):
SELECT
c.customer_id,
c.email,
c.name,
c.username,
s.subscription_id,
s.`date`
FROM
Tom Murdock [EMAIL PROTECTED] wrote:
Good evening,
I would like to subscribe to MySQL mailing list.
Thank you.
If you want to subscribe to MySQL mailing list, visit http://lists.mysql.com/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Good evening,
I would like to subscribe to MySQL mailing list.
Thank you.
Cedomilj
_
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
--
MySQL General Mailing
On Thu, 03 Jun 2004 14:56:23 -0500
Tom Murdock [EMAIL PROTECTED] wrote:
Good evening,
I would like to subscribe to MySQL mailing list.
Thank you.
Your wish appears to have been granted. :)
Josh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
list.
No special arrangements needed.
Best regards,
MySQL DB Supporter
- Original Message -
From: Tom Murdock [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 03, 2004 12:56 PM
Subject: Subscription
Good evening,
I would like to subscribe to MySQL mailing list.
Thank
Dear sir/Madam
I am a mysql developer and want to keep myself updating the events with
MySQL.
Thanking You
Regards
Amit Prakash
Software Engineer
Savitr Software Services (P) Ltd.
Hyderabad
-
Before posting, please check:
Hello,
I spent the last days with searching a solution for the following
problem:
We have to synchronise an MS SQL database in the USA with a mySQL
database in germany. The programmer who supports the database in the
USA likes to do that via a push-Subscription, which is an MS SQL
feature
Hi,
We have to synchronise an MS SQL database in the USA with a mySQL
database in germany. The programmer who supports the database in the
USA likes to do that via a push-Subscription, which is an MS SQL
feature (not a very save feature I read!?). So, my question is: Is
there a way to do
-Subscription, which is an MS SQL
feature (not a very save feature I read!?). So, my question is: Is
there a way to do that with these different Databases? And if not: Is
there another way to connect an MS SQL- to a mySQL database to Publish
a Database from one server to another? I've searched
Hello,
I spent the last days with searching a solution for the following
problem:
We have to synchronise an MS SQL database in the USA with a mySQL
database in germany. The programmer who supports the database in the USA
likes to do that via a push-Subscription, which is an MS SQL feature
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe,
14 matches
Mail list logo