;>>> 2012/02/29 15:29 -0600, Johnny Withers
Sounds like you need to LEFT JOIN:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND CALLS.DATE = "02/28/12"
WHERE CUSTOMERS.DATE = "02/28/12"
But that would only get customers created on 2/28 AND having a call on 2/28
OR
Be kind, I am by no means any type of DB expert.
I would like to eventually move this to a stored procedure but for now I
am using the \. to fire it off.
Here is what I have so far (generating a list of machines missing software)
select last_logon.host_name_short
from last_logon
left join mca
what about
select customers.* from customers left join calls on
(customers.date=calls.date) where customers.date="02/28/12";
of course date should be an index in both tables.
I think it migth work
On Wed, Feb 29, 2012 at 4:54 PM, LUCi5R wrote:
> JW,
>
>
>
> I'm trying to understand LEFT JOIN
JW,
I'm trying to understand LEFT JOIN as we go - but it's not working.
This query
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE
WHERE CUSTOMERS.DATE = "02/28/12" AND (CALLS.PHONE IS NULL OR CALLS.DATE =
"02/28/12")
Is giving me some results which
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu wrote:
> I created (or activated) the root account and now I see the error log:
>
> sh-3.2# cat miniMac.local.err
> 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
> /usr/local/mysql/data
> 120229 10:36:09 [Warning] Setting lower_cas
Looks like 5.1.61 mac installer messed up the privilege setting...
But how to fix it? I remember the server account is mysql, not _mysql
What do you got? And how to fix it? Thanks
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu wrote:
> I created (or activated) the root account and now I see the erro
Sounds like you need to LEFT JOIN:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND CALLS.DATE = "02/28/12"
WHERE CUSTOMERS.DATE = "02/28/12"
But that would only get customers created on 2/28 AND having a call on 2/28
OR not call at all on 2/28.
This would give you cu
I created (or activated) the root account and now I see the error log:
sh-3.2# cat miniMac.local.err
120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data
On 2/29/2012 1:15 PM, Don Wieland wrote:
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id =
If you are going to use "su" to officially switch to the root users
just make sure you do "su -" with the dash.
On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald wrote:
>
>
> Am 29.02.2012 19:20, schrieb Larry Martell:
>> Is the sudo succeeding? If it is, then there's no reason you shouldn't
>> be
You may be interested in this:
http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull
On Wed, Feb 29, 2012 at 13:15, Don Wieland wrote:
> Little help...
>
> In my mySQL query editor, I am trying to return a value of 0 when there is
> no related rows from this query:
>
> (select if(count(ip.payment_
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu wrote:
>
> -rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYING
> -rw-r--r-- 1 root wheel 7371 Dec 17 09:01 INSTALL-BINARY
> -rw-r--r-- 1 root wheel 2552 Dec 17 09:01 README
> drwxr-xr-x 46 root wheel 1564 Dec 17 09:01 bin
> drwxr-
It sounds like you've been handed a mandate that's difficult to
understand, but it could be because I don't understand the context, or
you may not understand your manager's real intention. In any case,
"everyone is doing clustering" is certainly not accurate. And every
"clustering" technology is
Are you looking in /usr/local/mysql/data ? You should see a
username.err file. You might have to sudo to open the file just do
"sudo tail -f FILENAME" or "sudo taill -f /path/to/filename/ ".
On Wed, Feb 29, 2012 at 1:00 PM, Elim Qiu wrote:
> -rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYI
-rw-r--r-- 1 rootwheel 17987 Dec 17 09:01 COPYING
-rw-r--r-- 1 rootwheel 7371 Dec 17 09:01 INSTALL-BINARY
-rw-r--r-- 1 rootwheel 2552 Dec 17 09:01 README
drwxr-xr-x 46 rootwheel 1564 Dec 17 09:01 bin
drwxr-x--- 8 _mysql wheel272 Feb 29 10:36 data
drwxr-xr-x 4
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id = ip.inv_id GROUP BY ip.inv_id) as d
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu wrote:
> Thanks Larry and Darryle for your help
>
> Where the error log should be?
http://dev.mysql.com/doc/refman/5.0/en/error-log.html
>
> On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell
> wrote:
>>
>> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell wrote:
> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote:
> > Yes, there is an icon. I can open the preference but the start service
> > button cannot do the job
>
> What is in t
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote:
> Yes, there is an icon. I can open the preference but the start service
> button cannot do the job
What is in the mysql error log?
>
> On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight
> wrote:
>
>> Do you see a MySql icon under System Prefer
I have version 5.5.17 MySQL Community Server (GPL) on my Mac.
On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu wrote:
> The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
> mac at mysql.com)
>
> On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu wrote:
>
>> *I downloaded **Mac OS X ver.
Yes, there is an icon. I can open the preference but the start service
button cannot do the job
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight
wrote:
> Do you see a MySql icon under System Preferences > Other ? That's how
> I start MySql on my Mac.
>
> **
>
>
>
>
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu wrote:
> *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed
> to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started
> apach
Do you see a MySql icon under System Preferences > Other ? That's how
I start MySql on my Mac.
On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu wrote:
> *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
> my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apac
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache.
The installation went smoothly but the service just cannot be started.*
**
- Original Message -
> From: "Charles Brown"
>
> Anyone out there with experience in Mysql Clustering. My management
> requests that i migrate from replication to clustering. Why? Because
> everyone is doing clustering and he would like to stay competitive.
Your management has no clue w
On 29/02/12 12:38, Brown, Charles wrote:
Hello,
Can someone give me syntax to create a user called starsky and password hutch
with the following objectives:
- user the minimum to run back scripts
- user has the minimum to lock tables
- user has the minimum to do SELECT on tables
Thx
**
27 matches
Mail list logo
