Re: dump, drop database then merge/aggregate

ggregating, adding data. > I think developers took care of uniqueness of the rows, and constructed it > in conformity with good design practices. > > What I'm only guessing is when I lock, dump and remove then insert, > aggregate could there be problems with keys? And no data loss during > dump+

Re: dump, drop database then merge/aggregate

Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith wrote: > On 29/02/2016 16:32, Steven Siebert wrote: > >> >> At risk of giving you too much rope to hang yourself: if you use >> mysqldump to dump

Re: dump, drop database then merge/aggregate

On 29/02/2016 16:32, Steven Siebert wrote: At risk of giving you too much rope to hang yourself: if you use mysqldump to dump the database, if you use the --replace flag you'll convert all INSERT statements to REPLACE, which when you merge will update or insert the record, effectively

Re: dump, drop database then merge/aggregate

think developers took care of uniqueness of the rows, and constructed it in conformity with good design practices. What I'm only guessing is when I lock, dump and remove then insert, aggregate could there be problems with keys? And no data loss during dump+removal? thanks for sharing your

Re: dump, drop database then merge/aggregate

gt;> you're after? >> >> I realize this all might look rather like a bird fiddling with a worm > instead of lion going for quick kill. I replicate wherever I need and can, > here a have very little control over one end. > On that end with little control there is one simple dat

Re: dump, drop database then merge/aggregate

- Original Message - > From: "lejeczek" <pelj...@yahoo.co.uk> > Subject: Re: dump, drop database then merge/aggregate > > today both databases are mirrored/identical > tonight awkward end will dump then remove all the data, then > collect some and again,

Re: dump, drop database then merge/aggregate

trol there is one simple database, which data I'll need to be removed on regular basis, before removing I'll be dumping and I need to use those dumps to add, merge, aggregate data to a database on the other end, like: today both databases are mirrored/identical tonight awkward end will

Re: dump, drop database then merge/aggregate

On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have

Re: dump, drop database then merge/aggregate

On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done

dump, drop database then merge/aggregate

fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done best. A box will be dumping a database

Re: Why does a group_concat on a join change aggregate values?

On 2015/05/07 19:42, Paul Halliday wrote: Should have showed the whole thing. Take a look here (click image to see full output): http://www.pintumbler.org/tmp I don't see why this worries you. Joining often increases variation. Indeed, if in some case an inner join never did, maybe the

Re: Why does a group_concat on a join change aggregate values?

() but once I do that JOIN things start to fall apart. What is happening behind the scenes? Thanks! Here's a simple test. Change the query to no longer have the aggregate functions, then start counting rows by hand. SELECT val AS n , types AS c_types , two.types AS d_types FROM tbl1 LEFT

Re: Why does a group_concat on a join change aggregate values?

the scenes? Thanks! Here's a simple test. Change the query to no longer have the aggregate functions, then start counting rows by hand. SELECT val AS n , types AS c_types , two.types AS d_types FROM tbl1 LEFT JOIN tbl2 AS two ON tbl1.id = tbl2.id The other thing that springs

Why does a group_concat on a join change aggregate values?

Fighting a bit with this one... If I do something like (pseudo): SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1 returns something like: n c_types 1 t9 when I add a left join though: SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types, GROUP_CONCAT(two.types) AS d_types

RE: Aggregate

2012/09/04 11:43 -0700, Rick James int(1) does not mean what you think. Probably you want TINYINT UNSIGNED. Yeap, a real misfeature of MySQL. It is also one of the ways wherin MySQL puts in C and takes PL1 away. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Aggregate

2012/09/04 11:43 -0700, Rick James You have DATETIME and TIMESTAMP. Keep in mind that TIMEZONE is timezone-aware; DATETIME is not. TIMEZONE is typo for TIMESTAMP? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: Aggregate

Aggregate question. -Original Message- From: Ron Piggott [mailto:ron.pigg...@actsministries.org] Sent: Friday, August 31, 2012 3:22 AM To: mysql@lists.mysql.com Subject: Aggregate I am unsure of which Aggregate function to use with the query (below) Right now thread_date_reference

Aggregate

I am unsure of which Aggregate function to use with the query (below) Right now thread_date_reference and last_post_membership_reference produce NULL results. I expect the NULL result is because of the LEFT OUTER JOIN and there being no matching JOIN in the table articles_discussion , as well

Aggregate Query

other tables. So the next thing I need to do is aggregate rows that are for the same item, at the same price. I've looked at GROUP BY but can't figure out how to get it to group rows with same product name and price, and generate a column with the total of the number of aggregated rows in each

RE: Within-group aggregate query help please - customers and latest subscription row

2011/10/24 16:31 -0700, Daevid Vincent WHERE cs.customer_id = 7 GROUP BY customer_id Well, the latter line is now redundant. How will you make the '7' into a parameter? -- MySQL General Mailing List For list archives:

Within-group aggregate query help please - customers and latest subscription row

I know this is a common problem, and I've been struggling with it for a full day now but I can't get it. I also tried a few sites for examples: http://www.artfulsoftware.com/infotree/queries.php#101 http://forums.devarticles.com/general-sql-development-47/select-max-datetime -problem-10210.html

RE: Within-group aggregate query help please - customers and latest subscription row

- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Monday, October 24, 2011 1:46 PM To: mysql@lists.mysql.com Subject: Within-group aggregate query help please - customers and latest subscription row I know this is a common problem, and I've been struggling with it for a full day now but I

RE: Within-group aggregate query help please - customers and latest subscription row

To: mysql@lists.mysql.com Subject: RE: Within-group aggregate query help please - customers and latest subscription row A kind (and shy) soul replied to me off list and suggested this solution, however, this takes 28 seconds (that's for a single customer_id, so this is not going to scale). Got

How do I (can I) use aggregate functions inside a select

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,

Re: How do I (can I) use aggregate functions inside a select

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) / sales

RE: How do I (can I) use aggregate functions inside a select

: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 10:37 AM To: David Ruggles Cc: mysql Subject: Re: How do I (can I) use aggregate functions inside a select yes, u can use the below sql. regards anandkl On 7/25/08, David Ruggles [EMAIL PROTECTED] wrote: I may be approaching

Re: How do I (can I) use aggregate functions inside a select

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

RE: How do I (can I) use aggregate functions inside a select

[EMAIL PROTECTED] -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 10:37 AM To: David Ruggles Cc: mysql Subject: Re: How do I (can I) use aggregate functions inside a select yes, u can use the below sql. regards anandkl

RE: How do I (can I) use aggregate functions inside a select

-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

FW: How do I (can I) use aggregate functions inside a select

PROTECTED] -Original Message- From: Ian Simpson [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 11:15 AM To: David Ruggles Cc: 'mysql' Subject: RE: How do I (can I) use aggregate functions inside a select Hi David, Try Select company, state, sales, sum(sales) / sales as percent From

Re: FW: How do I (can I) use aggregate functions inside a select

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

Re: Insert...on duplicate with aggregate

Awesome! Thanks Baron, works perfectly.. Phil On Tue, Feb 26, 2008 at 10:06 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi! On Tue, Feb 26, 2008 at 7:04 PM, Phil [EMAIL PROTECTED] wrote: I have a table countrystats defined as CREATE TABLE IF NOT EXISTS `countrystats` ( `proj`

Insert...on duplicate with aggregate

I have a table countrystats defined as CREATE TABLE IF NOT EXISTS `countrystats` ( `proj` char(6) NOT NULL default '', `country` char(50) NOT NULL default '', `score` double default NULL, `nusers` int(11) default NULL, `RAC` double default NULL, `last_update` double default NULL,

Re: Insert...on duplicate with aggregate

Hi! On Tue, Feb 26, 2008 at 7:04 PM, Phil [EMAIL PROTECTED] wrote: I have a table countrystats defined as CREATE TABLE IF NOT EXISTS `countrystats` ( `proj` char(6) NOT NULL default '', `country` char(50) NOT NULL default '', `score` double default NULL, `nusers` int(11) default

Re: Updating two fields from an aggregate query

Robert, you might give insert ... select ... on duplicate key update a try: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html something like this (untested): INSERT INTO parent (id, maxChildAge, childCount) SELECT parentid, MAX(age) as maxAge, COUNT(*) as ct FROM child WHERE parentid IN

Updating two fields from an aggregate query

I have two tables that are related: Parent LONG id LONG childCount LONG maxChildAge ... Child LONG parentId LONG age ... There can be thousands of parents and millions of children, that is why I have denormalized childCount and maxChildAge. The values are too expensive to

Re: RE: Updating two fields from an aggregate query

26, 2006 7:15 AM To: Robert DiFalco Cc: mysql@lists.mysql.com Subject: Re: Updating two fields from an aggregate query Robert, you might give insert ... select ... on duplicate key update a try: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html something like this (untested): INSERT

RE: Updating two fields from an aggregate query

: Tuesday, September 26, 2006 7:15 AM To: Robert DiFalco Cc: mysql@lists.mysql.com Subject: Re: Updating two fields from an aggregate query Robert, you might give insert ... select ... on duplicate key update a try: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html something like

Expressions, SQL Aggregate functions SELECT Performance - index usage

the max key value to be inserted in the table instead of using the auto-increment (because it's rollback-unfriendly). However, I wonder if using such expressions (I not using any other functions except SQL Aggregate functions) in the select column-list would slow down the INSERTs and what

Aggregate Function Help (first and last records)

Hi there, I am trying to figure out how to flatten the result set of a join query using aggregate functions. For several fields (b.refering_url, c.string, b.first_page, b.last_page) I need to pull out the _first_ or _last_ item as ordered from the records returned from the join. However

Re: Aggregate Function Help (first and last records)

aggregate functions. For several fields (b.refering_url, c.string, b.first_page, b.last_page) I need to pull out the _first_ or _last_ item as ordered from the records returned from the join. However, I'm just lost for how this would be accomplished. I'd like to say FIRST(col), or LAST(col). Any

Re: Aggregate Function Help (first and last records)

query using aggregate functions. For several fields (b.refering_url, c.string, b.first_page, b.last_page) I need to pull out the _first_ or _last_ item as ordered from the records returned from the join. However, I'm just lost for how this would be accomplished. I'd like

Re: Aggregate Function Help (first and last records)

research has come up with nil so far. Thanks, Michael Michael Caplan wrote: Hi there, I am trying to figure out how to flatten the result set of a join query using aggregate functions. For several fields

RE: Aggregate functions in ORDER BY

PROTECTED] Sent: Wednesday, March 08, 2006 11:10 PM To: Dave Pullin Cc: mysql@lists.mysql.com Subject: Re: Aggregate functions in ORDER BY Many thanks for that Dave. Do you know whether it's possible for MySQL to return fully qualified column names by default? For example, I'd like

Re: Aggregate functions in ORDER BY

11:10 PM To: Dave Pullin Cc: mysql@lists.mysql.com Subject: Re: Aggregate functions in ORDER BY Many thanks for that Dave. Do you know whether it's possible for MySQL to return fully qualified column names by default? For example, I'd like select * from foo; to return

Re: Aggregate functions in ORDER BY

Thanks for that Nicolas. Yasir Can you run without the Order By at all? If not, you may need to properly join the tables. I could reproduce the issue with MySQL 4.1 as well and I would go around it myself by creating a temporaty table, populating it with the aggregate, doing a select

Aggregate functions in ORDER BY

Hello, I noticed something strange in MySQL (I'm using 4.1.15). If I use an aggregate function in the ORDER BY clause I get an error. SELECT men.man_name, COUNT(pets.pet_id) FROM men, pets WHERE men.man_id = pets.pet_man_id GROUP BY men.man_id ORDER BY COUNT(pets.pet_id) DESC; gives

RE: Aggregate functions in ORDER BY

: Aggregate functions in ORDER BY Hello, I noticed something strange in MySQL (I'm using 4.1.15). If I use an aggregate function in the ORDER BY clause I get an error. SELECT men.man_name, COUNT(pets.pet_id) FROM men, pets WHERE men.man_id = pets.pet_man_id GROUP BY men.man_id ORDER

Re: Aggregate functions in ORDER BY

by count ) as subtable Dave -Original Message- From: Yasir Assam [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 9:10 PM To: mysql@lists.mysql.com Subject: Aggregate functions in ORDER BY Hello, I noticed something strange in MySQL (I'm using 4.1.15). If I use an aggregate

RE: Aggregate functions in ORDER BY

Can you run without the Order By at all? If not, you may need to properly join the tables. I could reproduce the issue with MySQL 4.1 as well and I would go around it myself by creating a temporaty table, populating it with the aggregate, doing a select on the temp table and then of course

JOINs with result of aggregate function fails with error #1054

a join with the result of an aggregate function (in this case MAX(id)) in one query, or do I have to use multiple queries for this? Thanks in advance! Guillaume

Re: JOINs with result of aggregate function fails with error #1054

DESC Is there a way to do a join with the result of an aggregate function (in this case MAX(id)) in one query, or do I have to use multiple queries for this? Thanks in advance! Guillaume You cannot join on an aggregate function. The value of maxid cannot be determined until after the join

Re: JOINs with result of aggregate function fails with error #1054

ON l2.id=maxid WHERE l.is_visible='1' GROUP BY l.host_address ORDER BY maxid DESC Is there a way to do a join with the result of an aggregate function (in this case MAX(id)) in one query, or do I have to use multiple queries for this? Thanks in advance! Guillaume You you will have

how to use row total in aggregate query ?

I have a query: I am trying to get a percentage of the total for each city SELECT userLog.city,userLog.region, COUNT(*), /* Count(userLog.id) is always 1 was hoping to get the total row returned */ COUNT(*)/COUNT(userLog.id), media.name,artist.name FROM userLog,media,artist WHERE

Re: aggregate count and group by

this in one query (or at least not have to send tons of queries over the network) but can't figure out how to aggregate the results. I'd like to get a result similar to the following: +---++---+ | keyword| previous clicks | current clicks

Re: aggregate count and group by

trying to figure out a way to do this in one query (or at least not have to send tons of queries over the network) but can't figure out how to aggregate the results. I'd like to get a result similar to the following: +---++---+ | keyword

aggregate count and group by

the network) but can't figure out how to aggregate the results. I'd like to get a result similar to the following: +---++---+ | keyword| previous clicks | current clicks

RE: is there a PRODUCT() or MULTIPLY() aggregate function?

: is there a PRODUCT() or MULTIPLY() aggregate function? Is there an aggregate function that multiplies column values just like SUM() adds them? For instance, if SELECT value FROM data returns three values 2, 3, and 4, then SELECT PRODUCT(value) FROM data would return 24, which is 2 * 3 * 4. Thanks

is there a PRODUCT() or MULTIPLY() aggregate function?

Is there an aggregate function that multiplies column values just like SUM() adds them? For instance, if SELECT value FROM data returns three values 2, 3, and 4, then SELECT PRODUCT(value) FROM data would return 24, which is 2 * 3 * 4. Thanks! --- Fyodor Golos Stockworm, Inc.

RE: is there a PRODUCT() or MULTIPLY() aggregate function?

No there is not. Two options could be to either create an UDF or use a programming language. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 5/25/04 1:25 PM Subject: is there a PRODUCT() or MULTIPLY() aggregate function? Is there an aggregate function

Re: Getting Aggregate Object Data

Lou Olsten [EMAIL PROTECTED] wrote: I'm in the process of trying to move some of our systems to MySQL from SQL Server and Oracle. At this point I'm learning and testing MySQL. One immediate question I have is regarding getting aggregate information. For example, the SHOW DATABASES

2 joins + aggregate-functions

+--+ | isl_player | +--+ | pla_id | | pla_username | +--+ +--+ | isl_login| +--+ | pla_id | | log_created | +--+ +--+ | isl_transfer | +--+ | pla_id | | tra_amount |

Getting Aggregate Object Data

I'm in the process of trying to move some of our systems to MySQL from SQL Server and Oracle. At this point I'm learning and testing MySQL. One immediate question I have is regarding getting aggregate information. For example, the SHOW DATABASES command would be an example of something I

Re: Subselect in aggregate function in MySQL 4.1.1a-alpha

multiple rows in only one col to an aggregate function. Thanks and bye, Bernhard - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 2:34 PM Subject: Re: Subselect in aggregate function in MySQL 4.1.1a-alpha [EMAIL

Subselect in aggregate function in MySQL 4.1.1a-alpha

the average number of requests per time. I thus thought I can use a subselect like SELECT AVG(SELECT COUNT(time) anz FROM table GROUP BY time) FROM table That seems impossible, it in fact simply does not work. Is it wrong by my design or is it MySQL design not to pass a subselect to an aggregate

Re: Subselect in aggregate function in MySQL 4.1.1a-alpha

not to pass a subselect to an aggregate function? If I've got you right you need: SELECT AVG(anz) FROM (SELECT COUNT(time) anz FROM table GROUP BY time) as table1; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http

Problem with aggregate UDF avgcost

Dear colleagues! I need to create my own aggregate UDF, so I decided to test UDF_example from Windows MySQL source. I've created udf_example.dll and udf_example.lib with VC++ 6.0. Then, I haven't any problem with all of udf's, excepting the aggregate udf avgcost. On my SELECT avgcost(a,b) from t1

Re: tough sql joining and aggregate question

Couldn't you also group by grouper2 and date2 ? Something like: ... GROUP BY grouper1, grouper2, date2 Just a hint I didn't test it. On Thu, 2003-10-16 at 01:01, Travis Reeder wrote: I am trying to do an aggregate query, but having some problems and here they are simplified: Table1

tough sql joining and aggregate question

I am trying to do an aggregate query, but having some problems and here they are simplified: Table1 date1 grouper1 x Table2 date2 grouper2 y Query is something like this: SELECT SUM(x) as sum_x, SUM(y) as sum_y FROM Table1 LEFT OUTER JOIN Table2 on grouper2 = grouper1 (date2 = '2003-07-01 00:00

one query, two tables, two aggregate functions

Hi, I would like to use one query to compare aggregate values from columns in two separate tables. I am running mysql 3.23.55 (max). Here is a simplified table structure: job - job_id - name quote - quote_id - job_id - quote_amount actual - actual_id - job_id - actual_amount I'm

RE: one query, two tables, two aggregate functions

] Sent: Friday, May 30, 2003 4:57 PM To: [EMAIL PROTECTED] Subject: one query, two tables, two aggregate functions Hi, I would like to use one query to compare aggregate values from columns in two separate tables. I am running mysql 3.23.55 (max). Here is a simplified table structure: job

invalid aggregate function value for 0 row results (from a full join)

Description: It appears that when an aggregate like MAX is used in a query, mysql will put any values in that it already has from internal statistics, however, this is wrong if the query being executed results in zero records, in this example, the MAX of zero

vb.net aggregate MySQL functions

I'm having problems with vb.net and MySQL, only on reading records returned with requests for functions, i.e., such as the following SELECT max(field1) AS MaxValue FROM Table1 or SELECT concat( field1, ' ', field2) as FullName FROM Table1 The queries work fine when executed directly

RE: aggregate functions producing bad data

by either query. Inspect the data in these rows manually to determine what is wrong. -Original Message- From: Richard Unger [mailto:[EMAIL PROTECTED]] Sent: September 17, 2002 21:00 To: [EMAIL PROTECTED] Subject: aggregate functions producing bad data My query: SELECT

re: Re: aggregate functions producing bad data

Jay, Tuesday, September 17, 2002, 10:45:51 PM, you wrote: J On my server the MySQL database decided to die on me. So I killed it and J restarted and that didn't work. So I just rebooted the machine. Now I'm J getting this error below. J Invalid SQL: SELECT COUNT(*) AS messages FROM

aggregate functions producing bad data

My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM t_calllog_calls; My result: 1994 1956 35 However, 1956 + 35 != 1994. Running MySQL 3.23.49-nt Cheers, Rich

Re: aggregate functions producing bad data

On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote: My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM t_calllog_calls; My result: 1994 1956 35 However, 1956

Re: aggregate functions producing bad data

Unger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 9:59 PM Subject: aggregate functions producing bad data My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM t_calllog_calls; My result

RE: aggregate functions producing bad data

I _thought_ it was the fault of the aggregate function, but now I'm really confused! When I produce them as 3 separate queries, I still get numbers that don't add up: mysql select count(id) from t_calllog_calls; +---+ | count(id) | +---+ | 1994 | +---+ 1 row in set

RE: aggregate functions producing bad data

, September 17, 2002 12:08 PM To: Richard Unger; [EMAIL PROTECTED] Subject: Re: aggregate functions producing bad data Hi, I think you should try to use 0 instead of NULL Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address

RE: aggregate functions producing bad data

id is the primary key. There are no entries in the DB where id=NULL Cheers, Rich -Original Message- From: Brian Reichert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 12:16 PM To: Richard Unger Cc: [EMAIL PROTECTED] Subject: Re: aggregate functions producing bad

Re: aggregate functions producing bad data

In the last episode (Sep 17), Brian Reichert said: On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote: My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM

RE: aggregate functions producing bad data

of calls. Cheers, Rich -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 12:08 PM To: Richard Unger; [EMAIL PROTECTED] Subject: Re: aggregate functions producing bad data Hi, I think you should try to use 0 instead

RE: aggregate functions producing bad data

-Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 12:31 PM To: Brian Reichert Cc: Richard Unger; [EMAIL PROTECTED] Subject: Re: aggregate functions producing bad data In the last episode (Sep 17), Brian Reichert said: On Tue, Sep

RE: aggregate functions producing bad data

: [EMAIL PROTECTED] Subject: RE: aggregate functions producing bad data what does Select count(id) from t_calllog_calls where id IS NULL give you? On Tue, 17 Sep 2002, Richard Unger wrote: That would just give me 1994 for all 3 columns of output. What I want to know is how many calls

Re: aggregate functions producing bad data

On my server the MySQL database decided to die on me. So I killed it and restarted and that didn't work. So I just rebooted the machine. Now I'm getting this error below. Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 mysql error: Can't open file:

Re: aggregate functions producing bad data

] - Original Message - From: Brian Reichert [EMAIL PROTECTED] To: Richard Unger [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 10:16 PM Subject: Re: aggregate functions producing bad data On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote: My query: SELECT

Re: aggregate functions producing bad data

PROTECTED] [EMAIL PROTECTED] - Original Message - From: Brian Reichert [EMAIL PROTECTED] To: Richard Unger [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 10:16 PM Subject: Re: aggregate functions producing bad data On Tue, Sep

Re: aggregate functions producing bad data

, September 17, 2002 10:16 PM Subject: Re: aggregate functions producing bad data On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote: My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM

FW: aggregate functions producing bad data

MySQL -- to defeat the spam filter -Original Message- From: Richard Unger Sent: Tuesday, September 17, 2002 1:46 PM To: 'Dan Nelson' Cc: [EMAIL PROTECTED] Subject: RE: aggregate functions producing bad data Thanks, I figured it out. It turns out there were some calls for which

Re: aggregate functions producing bad data

Hi. Could you run the following query: SELECTIF(call_end - call_start 5, id, NULL) AS long, IF(call_end - call_start = 5, id, NULL) AS short, COUNT(*) FROM t_calllog_calls GROUP BY long, short Given that I have not made any mistake, that should list all rows

Re: RES: Aggregate + left outer join (Solution)

Hi Eduardo, I found the solution the left outer join + aggregate problem I had earlier faced. the query should be SELECT p.nm_project, sum( dl.hours) FROM PROJECT p LEFT OUTER JOIN DAYLOG dl ON (p.id_project = dl.id_project

strange behaviour of aggregate functions in if() clauses

MySQL v3.23.49 linux Hi, We came across something strange here. select count(*), user from mysql.user; is illegal (ERROR 1140: Mixing of GROUP columns ... if there is no GROUP BY clause). But, select if( count(*) and user, 1, 0 ) from mysql.user; actually works. Is this a bug or

Aggregate + left outer join

Hi, I am relatively new to MySQL.. I am having trouble getting an aggregate function and an outer join to work together. I have two tables PROJECT (id_project, nm_project) 100, prj1 101, prj2 DAYLOG (id_project, date, hours) 100, 2002-08-17, 8 100, 2002-08-18, 8 DAYLOG table contains

Re: RES: Aggregate + left outer join

/PRTGROUP| | cc: | | Subject: RES: Aggregate + left outer join | ---| Hi, Try

Multiple joins with aggregate problem

I am having a or problem reproducible by script below (or by sql or by query if mail filter likes those words better:) ). Briefly: 4 tables joined to each other: /-ar a \-b-br I would expect to get totals based on the root record in a: a_idq_a q_arq_b q_br 1 1 4

Aggregate functions

Hi, Sorry to bother the Guru's here, but I've recently started working on getting a mySQL database up and running and I noticed that some aggregate functions like MAX and MIN don't have 'DISTINCT' as an optional arguement. Are these not supported or is this just missing from the documentation

Re: Aggregate functions

Kris, Friday, June 07, 2002, 1:21:48 PM, you wrote: KS Sorry to bother the Guru's here, but I've recently started working on KS getting a mySQL database up and running and I noticed that some KS aggregate functions like MAX and MIN don't have 'DISTINCT' as an KS optional arguement

RE: geometric mean aggregate function

Walker Senior Software Engineer ePliant Marketing -Original Message- From: Andrew Gould [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 11, 2002 6:51 AM To: [EMAIL PROTECTED] Subject: geometric mean aggregate function Has anyone out there developed a costum, aggregate function for calculating

RE: geometric mean aggregate function

, 2002 7:51 AM To: [EMAIL PROTECTED] Subject: geometric mean aggregate function Has anyone out there developed a costum, aggregate function for calculating the geometric mean of populations? If not, would anyone be interested in creating one? My development experience/skills is limited

  1   2   >