At 06:46 PM 7/25/2008, you wrote:
List,
I am bulk inserting a huge amount of data into a MyISAM table (a
wikipedia page dump).
Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE
KEYS; LOCK TABLES page WRITE;
The dump consists of about 1,200 bulk INSERT statements with roughly
A changing world brings freshness. We can prove that reading makes a perfect
man.Pick up a copy of Weekly Headline News
Try it today and leave a mark and thank you note.
http://weeklyheadlinenews.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Am Freitag 25 Juli 2008 21:19:53 schrieb [EMAIL PROTECTED]:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/u/mysql/488a2759cd767dbb/lists=feilner-it.net
>
> This confirmation serves
Am Freitag 25 Juli 2008 21:19:56 schrieb [EMAIL PROTECTED]:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/u/mysql/488a275c5444d766/lists=feilner-it.net
>
> This confirmation serves
List,
I am bulk inserting a huge amount of data into a MyISAM table (a
wikipedia page dump).
Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE
KEYS; LOCK TABLES page WRITE;
The dump consists of about 1,200 bulk INSERT statements with roughly
12,000 tuples each.
For the
I have a memory table with a few hundred thousand rows. As soon as I add an
index to the table, it loses 75% of the rows! No error is produced in the
log file or on the client machine. The rows 'A' to 'E' are present, but
rows 'F' to 'Z' are missing.
I have max_heap_table_size=1024M and tmp_ta
Why? Because it's Friday and I'm feeling silly :)
mysql> SELECT * FROM sales;
+--+---++
| company | state | sales |
+--+---++
| ABC | AZ| 140.01 |
| XYZ | AZ| 17.76 |
| ABC | NY| 123.45 |
| XYZ
On Fri, Jul 25, 2008 at 12:35 PM, Arthur Fuller <[EMAIL PROTECTED]> wrote:
> ORDER BY implies a sort of the result set. I don't think there is any way
> around that.
I guess so. What I am doing is to just run the query once per day and
store the results in memcache.
Michael
>
> Arthur
>
> On Fr
Sum() is driven by the group by.
I need it to be equivalent to this:
Select company, state, sales, sales / (select sum(sales) from sales) as
percent from sales
Which of course I could just use that, but the select I'm actually working
with isn't that simple and if there was some way to do what I
>-Original Message-
>From: David Ruggles [mailto:[EMAIL PROTECTED]
>Sent: Friday, July 25, 2008 10:53 AM
>To: 'mysql'
>Subject: RE: How do I (can I) use aggregate functions inside a select
>
>I get:
>Error Code : 1140
>Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns
Hi David,
Try
Select company, state, sales, sum(sales) / sales as percent
>From Sales GROUP BY company, state;
Not sure if you always want to group by state; if each company exists in
only one state then the group by is irrelevant, if not then it will give
you the by-state breakdown.
On Fri,
David Ruggles wrote:
> I may be approaching this all wrong, but I need to know a percentage of
> total sales within a select statement.
>
> So I can do something like this:
> Select company, state, sales, sum(sales) / sales as percent
> From Sales
>
>
mmh, you want
sum(sales where compan
I get:
Error Code : 1140
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is
illegal if there is no GROUP BY clause
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: Anan
yes, u can use the below sql.
regards
anandkl
On 7/25/08, David Ruggles <[EMAIL PROTECTED]> wrote:
>
> I may be approaching this all wrong, but I need to know a percentage of
> total sales within a select statement.
>
> So I can do something like this:
> Select company, state, sales, sum(sales)
I may be approaching this all wrong, but I need to know a percentage of
total sales within a select statement.
So I can do something like this:
Select company, state, sales, sum(sales) / sales as percent
>From Sales
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data,
On Fri, Jul 25, 2008 at 12:27 AM, Michael Stearne <[EMAIL PROTECTED]> wrote:
> I have a query:
>
> SELECT Country, COUNT( Country ) AS Cnt
> FROM properties WHERE (
> Country != 'USA' AND
> Country != 'US' AND
> Country != 'Unit' AND
> Country != 'United States'
> AND
I have a query:
SELECT Country, COUNT( Country ) AS Cnt FROM properties WHERE (
Country != 'USA' AND Country != 'US' AND Country != 'Unit' AND Country
!= 'United States' AND Country != ' ' AND Country IS NOT NULL ) GROUP
BY Country ORDER BY Cnt DESC LIMIT 8
that gets the top 8 non-US countries fr
17 matches
Mail list logo
