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
Hi Jason,
On Mon, Feb 2, 2009 at 7:27 PM, Jason Pruim japr...@raoset.com 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
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:
-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 addresses, and
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
On Mon, Feb 2, 2009 at 13:43, Martin Gainty mgai...@hotmail.com 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
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:
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
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
Quoth Walter Heck li...@olindata.com:
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
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.
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 out
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
tobias.stoc...@ch.netstream.com
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)
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
Quoth Baron Schwartz ba...@xaprb.com:
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
16 matches
Mail list logo