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: http://l
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: 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
TABLE `customers_subscriptions` (
`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
"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 i
iling 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 lik
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 unsub
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 L
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:
htt
es 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 that with these different Databases? And if not: Is
> there another way to connect an MS SQL- to a mySQL database to Publish
> a Datab
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
>
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
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, e-ma
14 matches
Mail list logo
