On Fri, Oct 17, 2008 at 2:19 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Fri, Oct 17, 2008 at 2:15 PM, Ian Christian <[EMAIL PROTECTED]>wrote:
>
>> 2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
>> > On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]>
>> wrote:
>> >
>> >> Okay, I
2008/10/17 Reyna.Sabina <[EMAIL PROTECTED]>:
> Hi,
>
> Running Environment:
> MySQL Server version: 5.0.45
> OS is Red-Hat 64-bit
>
> The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors'
> using DELETE follows:
>
Perhaps I'm missing something - but a delete matching no
On Fri, Oct 17, 2008 at 2:15 PM, Ian Christian <[EMAIL PROTECTED]> wrote:
> 2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> > On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]>
> wrote:
> >
> >> Okay, I realize that query won't work, but that's essentially want I
> want
> >> to do:
>
Hi,
Running Environment:
MySQL Server version: 5.0.45
OS is Red-Hat 64-bit
The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors'
using DELETE follows:
(1) linux>sqlstmt="USE test; DELETE FROM junk WHERE id =4; SELECT
@@error_count;"
linux>mysal -e "$sqlstmt"
+--
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> wrote:
>
>> Okay, I realize that query won't work, but that's essentially want I want
>> to do:
>>
>> Add four months to the current date, then return the first day of that
>> month, e.g
In the last episode (Oct 17), Rene Fournier said:
> Okay, I realize that query won't work, but that's essentially want I
> want to do:
>
> Add four months to the current date, then return the first day of that
> month, e.g.:
>
> floor ( 2008-10-16 + 4 months ) = 2009-02-1
Since you kno
On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> wrote:
> Okay, I realize that query won't work, but that's essentially want I want
> to do:
>
> Add four months to the current date, then return the first day of that
> month, e.g.:
>
>floor ( 2008-10-16 + 4 months ) = 2009
Okay, I realize that query won't work, but that's essentially want I
want to do:
Add four months to the current date, then return the first day of that
month, e.g.:
floor ( 2008-10-16 + 4 months ) = 2009-02-1
Is there a nice SQL way of achieving this?
...Rene
--
MySQL General Mai
2008/10/17 Brent Baisley <[EMAIL PROTECTED]>:
> Why are you creating a subquery/derived table?
>
> Just change your limit to 1,2
> ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Because then the maths in the select part isn't executed, and I don't
get the figures I need.
--
MySQL General Maili
Why are you creating a subquery/derived table?
Just change your limit to 1,2
ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Like you did in the outer query.
Brent
On Fri, Oct 17, 2008 at 5:12 AM, Ian Christian <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm trying to work out the difference in a
On Fri, Oct 17, 2008 at 10:31 AM, Ian Christian <[EMAIL PROTECTED]> wrote:
> 2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
>
> > *How long does the second query actually take to run compared to first?
>
> Actually, really quickly - so quickly that I also suspected that a
> full table scan was not ta
2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>:
> *How long does the second query actually take to run compared to first?
Actually, really quickly - so quickly that I also suspected that a
full table scan was not taking place. I'd like to understand how the
output of EXPLAIN can differ from the act
hey martin...
thanks, and this is different.. someone else replied that alll i had to do,
was to start two sessions of mysql in different xterm windows, and i'd be
using both processesors. and that didn't sound right..
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sen
On Fri, Oct 17, 2008 at 9:56 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 17, 2008 at 2:12 AM, Ian Christian <[EMAIL PROTECTED]>wrote:
>
>> Hi all,
>>
>> I'm trying to work out the difference in a field between the last 2
>> updates in an updates table. I'm doing this as shown below:
On Fri, Oct 17, 2008 at 2:12 AM, Ian Christian <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm trying to work out the difference in a field between the last 2
> updates in an updates table. I'm doing this as shown below:
>
> mysql>SELECT
>-> (@in - AcctInputOctets) AS AcctInputOctets,
hi ron.
forgive me, so running mulitple instances of mysql (the client) will bounce
between dual processors???
h...
i'll check it out. never really thought about how to test this, thanks..
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008
In the last episode (Oct 17), bruce said:
> From: Dan Nelson
> > In the last episode (Oct 17), Marten Lehmann said:
> > > we are using MySQL 4.1 and 5 on AMD dual core processors, but I can
> > > only see one mysqld process on each machine. Since a process is
> > > always tied to a certain processo
sorry..
my bad,
i was looking for the exact sequence of cmds that i could type in, in order to
test this!!... sorry for the confusion..
thanks
-Original Message-
From: ?? [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 8:26 AM
To: bruce
Cc: Dan Nelson; Marten Lehmann; mysql@l
2008/10/17 bruce <[EMAIL PROTECTED]>
> hi...
>
> a sa short test, how would one demonstrate this from the cli.., using the
> mysql cmd interface??
>
Right, you also can use it in other editor,such as mysql-front editor or
sql server
>
> thanks
>
>
> -Original Message-
> From: Dan Nelson
hi...
a sa short test, how would one demonstrate this from the cli.., using the
mysql cmd interface??
thanks
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 7:59 AM
To: Marten Lehmann
Cc: mysql@lists.mysql.com
Subject: Re: MySQL und dual core
In the last episode (Oct 17), Marten Lehmann said:
> we are using MySQL 4.1 and 5 on AMD dual core processors, but I can
> only see one mysqld process on each machine. Since a process is
> always tied to a certain processor, mysqld doesn't seem to make use
> of the second core. As far as I know mul
Good point, I do however need this for simpliefied display purposes only,
the information in these tables I do otherwise not need for anything.
But I will keep this in mind next time I have a similar issue.
Thanks
Olaf
On 10/17/08 9:09 AM, "Martin Gainty" <[EMAIL PROTECTED]> wrote:
> Good Morn
Hello,
we are using MySQL 4.1 and 5 on AMD dual core processors, but I can only
see one mysqld process on each machine. Since a process is always tied
to a certain processor, mysqld doesn't seem to make use of the second
core. As far as I know multiple threads of one process would be visible
SELECT ID_number, count( CU_number )
FROM MyTable
GROUP BY ID_number
order by 2 desc
limit 10
will give you the top 10. Change 10 to whatever you want or take off the
limit clause to get all records.
On Fri, Oct 17, 2008 at 4:25 AM, dave aptiva <[EMAIL PROTECTED]>wrote:
> Hello all,
>
> I'm new
2008/10/16 Krishna Chandra Prajapati <[EMAIL PROTECTED]>:
> I believe that yahoo, google and other companies must be generating reports.
> How they are doing. Any Idea.
This is how google do it: http://en.wikipedia.org/wiki/MapReduce
Have you seen federated tables? Be aware of the performance on
Hello all,
I'm new to sql and have a question if someone would be kind enough to help
me with, if I have a table that stores telemarketers by ID_number and the
customer that they spoke to by CU_number and I use a select statement such
as;
SELECT ID_number, count( CU_number )
FROM MyTable
G
2008/10/17 dave aptiva <[EMAIL PROTECTED]>:
>
> I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error
> "# - Invalid use of group function "
# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table moo (id_number, cu_number);
sqlite> insert int
Hello all,
I'm new to sql and have a question if someone would be kind enough to help
me with, if I have a table that stores telemarketers by ID_number and the
customer that they spoke to by CU_number and I use a select statement such
as;
SELECT ID_number, count( CU_number )
FROM MyTable
G
Hi all,
I'm trying to work out the difference in a field between the last 2
updates in an updates table. I'm doing this as shown below:
mysql>SELECT
-> (@in - AcctInputOctets) AS AcctInputOctets,
-> (@out - AcctOutputOctets) AS AcctOutputOctets,
-> (@in := AcctInp
Hi Ujang
I could reproduce the same error mentioned by you in the actual post even
after having all of the packages for MySQL. Figuring out the what could be
the problem .
Thanks & Regards
Sudhir Menon
30 matches
Mail list logo
