Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
WHERE a.zipcode = 94949
AND (3956 * (2 *
Joerg Bruehe wrote:
Hi Fredrik, all!
Fredrik Andersson wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation.
[[...]]
In addition to permissions (see the other posts), there is another
possible problem:
Depending on how your environment is set up, the MySQL
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
Is that correct? Or 5.0.5 came first and then came 5.0.22?
--
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am replying to my own post to clarify my query. Actually, I have
5.0.22 installed and I want to use the BIT data-type on InnoDB Engine.
Can I do it or do I have to install 5.0.5 version (which is not
stable) ?
--
TIA
Asif
On 6/24/06, Asif Lodhi [EMAIL PROTECTED] wrote:
Hi,
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
/etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start
the system. But it has to be done every time I turn on the computer. I
do not understand your patch. I
On Saturday 24 June 2006 12:50, Asif Lodhi wrote:
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
Is that correct? Or 5.0.5 came first and then came 5.0.22?
After. 5 22.
Major.Minor.Release
--
Scanned by iCritical.
--
MySQL General Mailing List
For list
Duncan Hill wrote:
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
/etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start
the system. But it has to be done every time I turn on the computer. I
do not
the thing with JOINs are you gotta JOIN a table ON another table where
something matches something else (in most cases). I tried to clean this up a
bit but im rather new to mysql.
SELECT DISTINCT
(td.td_id),
td.venue_id as ven_id,
td.td_date as td_date,
art.NAME as art_name,
art.WEB as art_url,
Karl Larsen wrote:
I and a friend have written SQL to big Oracle DB but not much to
MySQL on our own computers. I find that there is a QUERY in the list for
MySQL but it does nothing much. Also I was glancing through the mamouth
MySQL reference manual and saw there are a bunch of tools that
H - try adding a group by b.zipcode to the end ...
Dan
Scott Haneda wrote:
Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
John Hicks wrote:
Karl Larsen wrote:
I and a friend have written SQL to big Oracle DB but not much to
MySQL on our own computers. I find that there is a QUERY in the list
for MySQL but it does nothing much. Also I was glancing through the
mamouth MySQL reference manual and saw there are a
Hi,
The table has ~2 million records and has 3 columns one of which is a text
field which on an average has 2000 characters(English alphabets, space are
there for now, but if required can be eliminated).
eg: adfastsdfasgadfdfdsaffagdasfd adfsadfadsgdsfdfsdfsgsdfdsg fg adfafg
2006/6/24, Asif Lodhi [EMAIL PROTECTED]:
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
mathematically speaking, there no such number like 5.0.5 anyway...
5.05 perhaps...
MySQL are numbered according to a X.Y.Z release number.
X : is the major version, where major
i don't know the proper place to send this and i didn't see any
mention of it in the list archives. there is a really small problem
with the configure script in 5.1.11 (and other versions, perhaps, but
i haven't looked) that prevents building with openssl support. patch
below.
thanks,
Hi all i am compiling mysql 4.1.20 with he following options:
export CFLAGS=-O3 -fomit-frame-pointer -march=nocona -msse3
export CXXFLAGS=-O3 -fomit-frame-pointer -felide-constructors
-march=nocona -msse3
./configure --prefix=/opt/.mysql-4.1.20 --enable-assembler
Hello List!
Does anybody know how to select and build a result set from two or more
databases with the same table structures that are on the same server.
I need the query to select the data from table1 on db1 and then select the
data from table1 on db2 and return a result of where if a field
I need the query to select the data from table1 on db1 and then
select the
data from table1 on db2 and return a result of where if a field
data value
is found in both tables that matches on name for example, it would
count the
occurrences.
Not entirely clear. Do you mean ...
SELECT
Hi, is usual to have a lot of HD writing on a MySQL server where (according
to mytop) there are between 800 and 1200 queries per second? my MRTG is
showing a lot of HD Writing and i wanted to know if it's usual. The database
is growing about 11 MB every 3 minutes.
FYI, I don't have any log-type
At 06:55 PM 6/24/2006, Santiago del Castillo wrote:
Hi, is usual to have a lot of HD writing on a MySQL server where (according
to mytop) there are between 800 and 1200 queries per second? my MRTG is
showing a lot of HD Writing and i wanted to know if it's usual. The database
is growing about 11
19 matches
Mail list logo