Quoth Baron Schwartz :
> So I assume you have a terabyte of RAM in the server, since you didn't
> say... OMG, it's using 143GB of RAM when it's idle? Wow..
>
> :-) You need to provide some more details here. I can't judge
> whether there is any issue at all.
Sorry. My VPS has 144 MB of RAM so
So I assume you have a terabyte of RAM in the server, since you didn't
say... OMG, it's using 143GB of RAM when it's idle? Wow..
:-) You need to provide some more details here. I can't judge
whether there is any issue at all.
Baron
On Sun, Feb 1, 2009 at 8:35 AM, Sebastian Tennant
wrote:
> H
This is going to return duplicate rows if there are results that match
both conditions. One of the queries needs a condition to exclude the
results that'll be sent in the other query.
You can do it this way, and in some cases it's faster. But, what I
think we should really be asking is:
1) what
Send the value of @@server_id in the message, and make sure each
server has a unique value for that. Compare the value in the received
message to the value in the server and see whether you should stop the
loop.
On Mon, Feb 2, 2009 at 4:38 AM, Tobias Stocker
wrote:
> Hy there,
>
> I'm planing to
I downloaded this for Ubuntu and installed (after installing libzip1
which was required BTW)
So, Workbench loads, but I don't see any way to connect to my mySQL
server (I'm not running my DB locally as it has > 1/2 Billion rows).
I did a quick search and found this rather disappointing page:
http
On Mon, Feb 2, 2009 at 13:43, Martin Gainty wrote:
>
> select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
> NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
That hit the nail right on the head. That was the same thing I
was going to suggest, Martin. I think people tend to forget that
MySQL
Why use a cannon on a gnat?
Your data is already in an Excel spreadsheet, so why not use Excel to do
this?
=ISODD(LEFT(A1,SEARCH(" ",A1)-1))
Will be true if the street number is odd; then you can just filter on that
column to select the "TRUE" rows, and copy them to wherever you need them.
>---
On Feb 2, 2009, at 1:41 PM, Christoph Boget wrote:
I was wondering if something was possible, I have an excel file
right now of
US mailing addresses, and what I need to do is select all the odd
numbered
addresses on one road, is there an easy way I can do that from
MySQL? the
addresses co
Jason
try
select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
SUBSTR(ADDRESS,1,INSTR(ADDRESS,'',1))
1232 Main
1234 Main
HTH
Martin
_
> -Original Message-
> From: Jason Pruim [mailto:japr...@raoset.com]
> Sent: Monday, 02 February 2009 13:27
> To: mysql@lists.mysql.com
> Subject: grabbing even addresses?
>
> Hello!
>
> I was wondering if something was possible, I have an excel
> file right now of US mailing address
> I was wondering if something was possible, I have an excel file right now of
> US mailing addresses, and what I need to do is select all the odd numbered
> addresses on one road, is there an easy way I can do that from MySQL? the
> addresses could contain 3, 4 or 5 numbers per addresses such as:
Hi Jason,
On Mon, Feb 2, 2009 at 7:27 PM, Jason Pruim wrote:
> Hello!
>
> I was wondering if something was possible, I have an excel file right now of
> US mailing addresses, and what I need to do is select all the odd numbered
> addresses on one road, is there an easy way I can do that from MySQ
Hello!
I was wondering if something was possible, I have an excel file right
now of US mailing addresses, and what I need to do is select all the
odd numbered addresses on one road, is there an easy way I can do
that from MySQL? the addresses could contain 3, 4 or 5 numbers per
addresses
Quoth wult...@gmail.com:
> Through your conf file(s) you have told MySQL how much memory it may
> consume. As long as the server does not go beyond what it is told it
> may consume it is not doing anything wrong.
Thanks. I'll have a look in the conf file. At the moment it's running
as it came ou
Quoth Walter Heck :
> You could bring it down, but the real question is if you really want
> to do that? Making the buffers and caches smaller will reduce the
> memory used, but it also reduces performance.
Noted.
> Could you tell us what you are hoping to use MySQL for and why you
> wanna bring
Hy there,
I'm planing to to build a small "partial replication" on MySQL 5.0 using the
Spread Toolkit and the Message API for MySQL. Therefore I'll create a trigger
(on insert) which fetches the row and sends it to the message group XY.
I was wondering if there is a way to tell MySQL in an SQL
16 matches
Mail list logo
