Re: Group by column and Sum another

: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=omel...@gmail.com -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: Does mysql support materialized views?

the fact tables cheers -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Does mysql support materialized views?

On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com wrote: Hi  Olexandr Melnyk That's to say, create the aggregation tables and update them by triggers? I've noticed a update view in Mysql , can it work under the aggretate operation? You're not looking for views, you need to use

Fwd: Does mysql support materialized views?

cache is something like the Snapshotone of the s mod listed in the query is modified, the in Oracle, so we can get the result immediately? On Mon, Apr 20, 2009 at 11:47 AM, Olexandr Melnyk omel...@gmail.com wrote: On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com wrote: Hi

Re: displaying a specific row within a group by

in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.49/2050 - Release Date: 04/09/09 10:27:00 -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: DELETED records still exist?

__ This email has been scanned by the CAMH Email Security System. __ -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: SELECT through many databases

Hello Andre, I would recommend you to rethink your criteria (if there's any) for splitting data into multiple tables. Because now. the more tables you add, the more of a performance problem it may cause. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ On Fri, Nov 21, 2008 at 9:58 PM

Re: SELECT through many databases

Unless that's disallowed too, you could use a couple of triggers which would update the stats table(s) on insert/delete/update to the main tables in each database. Sincerely yours, Olexandr Melnyk http://omelnyk.net/ On Fri, Nov 21, 2008 at 10:31 PM, Andre Matos [EMAIL PROTECTED]wrote

Re: how to generate the following output in sql ?

| | SND2008-11-012008-11-05 2008-11-102008-11-01 | MND2008-11-032008-11-15 2008-11-15 2008-11-02 | | how can I do this in sql any help will be appriciated. Thanks in advance -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: ORDER BY Help

query like SELECT ProductName FROM Products WHERE ProductScore 100 ORDER BY ProductScore However, how can I order by ProductScore, but ensure the product with ID 125 is at the top ? Is this possible. Thanks Neil -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: ORDER BY Help

, Olexandr Melnyk [EMAIL PROTECTED]wrote: SELECT ProductName FROM Products WHERE ProductScore 100 ORDER BY CASE WHEN ProductScore = 125 THEN 0 ELSE 1 END, ProductScore But this query won't use an index, so it would be a good idea to do this in two queries 2008/10/24 Tompkins Neil [EMAIL

Re: ORDER BY Help

160 Green Light 0.115 Is this possible ? On Fri, Oct 24, 2008 at 2:28 PM, Olexandr Melnyk [EMAIL PROTECTED]wrote: SELECT ProductID, ProductName, AVG(ProductScore * Quantity) AS a FROM Products GROUP BY ProductID ORDER BY a DESC 2008/10/24

Re: ORDER BY Help

at 2:49 PM, Olexandr Melnyk [EMAIL PROTECTED]wrote: Could give us sample values for a field? Should it contain the same thing as in the query I've sent? 2008/10/24, Tompkins Neil [EMAIL PROTECTED]: Hi This works, however I still want to be able to list the whole list like because I need

Re: MyISAM optimize

archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: Problem with GROUP BY

:40 PM -- -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: Tables are too wide

bar that I can use? Or what can I do to split the table output to fit on my screen? Thanks, -Alex -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: Relational Databasing on busy webserver

country and state names, from a different programming language. Plus, if the same query is run very often and table is almost static, chances are high that the result will be in query cache. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: Relational Databasing on busy webserver

On Tue, Sep 23, 2008 at 6:13 PM, Olexandr Melnyk [EMAIL PROTECTED] wrote: Plus, if the same query is run very often and table is almost static, chances are high that the result will be in query cache. Just realized that I haven't mentioned that this sentence is related to storing states

Re: too many connections

] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: too many connections

PROTECTED]mailto:[EMAIL PROTECTED] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: too many connections

Then killing the server process should be safe. Except that server startup may take a while. On Fri, Sep 19, 2008 at 7:25 PM, Kinney, Gail [EMAIL PROTECTED]wrote: We are using the default storage engine - INNODB *From:* Olexandr Melnyk [mailto:[EMAIL PROTECTED] *Sent:* Friday, September

Re: CONCAT doesn't work with NULL?

] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Indices in InnoDB/MySQL

columns value, as a way of referencing the associated row. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: MySQL and MS SQL Server 2005

. Jonathan Trahair -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: MySQL and MS SQL Server 2005

... SELECT FROM...WHERE...ORDER BY... Thanks in advance. Jonathan Trahair -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Fwd: auto increment format

archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: consitent backup of MyISAM and Innodb tables

://lists.mysql.com/[EMAIL PROTECTED] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: giving a row the new highest id

For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: giving a row the new highest id

Err.. you can do this: update table mytable set id = (select max(id) + 1 from user) where id = $oldid but I would recommend to use a transaction 2007/7/11, Olexandr Melnyk [EMAIL PROTECTED]: update table mytable set id =last_insert_id() + 1 where id = $oldid 2007/7/11, Olav Mørkrid [EMAIL

Re: giving a row the new highest id

General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: selecting everyting from 2 non-identical tables.

select id, name, age, null as height from table1 union select id, name, null as age, height from table2 2007/6/19, [EMAIL PROTECTED] [EMAIL PROTECTED]: select * from table1, table2 seems to give repeat rows for some reason. It is a Cartesian product. -- Sincerely yours, Olexandr Melnyk

Re: selecting everyting from 2 non-identical tables.

2007/6/19, [EMAIL PROTECTED] [EMAIL PROTECTED]: My frist post was not worded correctly. I cannot join two tables as all the rows are unique. What's wrong with my solution? 2007/6/19, Olexandr Melnyk [EMAIL PROTECTED]: select id, name, age, null as height from table1 union select id

Re: Object-Oriented database

have it. - Olexandr Melnyk, http://omelnyk.net/ 2007/5/4, sam rumaizan [EMAIL PROTECTED]: Is there such thing call Object-Oriented database for mysql? Basically can I store an item as an object in myql

Database with a lot of views

overhead in database containing a lot (millions) of views? Yours faithfully, Olexandr Melnyk

Re: Group By / Order BY

To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] - Olexandr Melnyk, http://omelnyk.net/

Performace of a database with a lot of tables

? The former is more important. Olexandr Melnyk, http://omelnyk.net/

Re: problem with update innodb table

Posting you table difinitions and queries would be helpful. Olexandr Melnyk, http://omelnyk.net/ 2007/2/8, Alicia Amadoz [EMAIL PROTECTED]: Hello, I am trying to update two fields of a table that are a composed foreign key to another table. These fields cant

Re: SELECT from 3 tables - Need help

queries with asterisks in production systems. And, as Chris mentioned, it is also recommended to always specify the table name for multi-table queries. Olexandr Melnyk, http://omelnyk.net/