Re: Group by column and Sum another

> Any suggestions? > > Hagen Finley > > Boulder > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=omel...@gmail.com > > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Fwd: Does mysql support materialized views?

well MySQL, the query 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 wrote: >> >> On Mon, Apr 20, 2009 at 12:4

Re: Does mysql support materialized views?

On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun 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

Re: Does mysql support materialized views?

need to create 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: displaying a specific row within a "group by"

; which does not depend on sorting, but which would require >> a surrogate primary key which I find even less elegant >> than relying a subquery. >> >> >> >> >> >> = >> The Webmechs Webpress blog >> http://www.webmechs.com/webpress/ >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> No virus found 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://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: DELETED records still exist?

e it? > > Thank you kindly > Ariela > > __ > This email has been scanned by the CAMH Email Security System. > ______ -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

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]>wr

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:

Re: how to generate the following output in sql ?

t; | 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

6.01, or 10.19. > > Neil > > On Fri, Oct 24, 2008 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

Re: ORDER BY Help

5 > %2008-11-11160 Green Light > 0.065 > %2008-11-12160 Green Light > 0.115 > Is this possible ? > On Fri, Oct 24, 2008 at 2:28 PM, Olexandr Melnyk <[EMAIL PROT

Re: ORDER BY Help

Tompkins Neil < > [EMAIL PROTECTED]> wrote: > >> Thanks for the reply, this is exactly what I wanted. >> >> Cheers Olexandr ! >> >> On Fri, Oct 24, 2008 at 1:26 PM, Olexandr Melnyk <[EMAIL PROTECTED]>wrote: >> >>> SELECT ProductName FROM Pro

Re: ORDER BY Help

> I've the following basic 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. > >

Re: MyISAM optimize

please notify us > immediately by reply e-mail and destroy all copies of the original > message. Thank you. > > > -- > MySQL 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: Problem with GROUP BY

clause but got nowhere. >> >> Can anybody help please ? >> >> TTFN, >> >> Philip Riebold, [EMAIL PROTECTED] /"\ >> Media Services\ / >> University College London X ASCII Ribbon Campaign >> Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail >> London, W1T 4JF >> +44 (0)20 7679 9259 (switchboard), 09259 (internal) >> >> >> >> >> >> Internal Virus Database is out of date. >> Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: >> 270.7.6/1713 - Release Date: 10/7/2008 6:40 PM >> >> >> > -- -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: Tables are too wide

ux that has a horizontal scroll > 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

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 relat

Re: Relational Databasing on busy webserver

rsome. Another problem will arise if you want to view user information, along with full 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: 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 PROTEC

Re: too many connections

just gotten an error: too many > connections. we can't connect to our site using MySQL admin. Please help. > > Gail Kinney > Webmaster UC Denver > [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> > > > > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/

Re: too many connections

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

Re: CONCAT doesn't work with NULL?

works fine. > > Why is that? > > -afan > > -- > MySQL 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/

Indices in InnoDB/MySQL

s the primary key values alongside the indexed columns value, as a way of referencing the associated row. -- Sincerely yours, Olexandr Melnyk <>< http://omelnyk.net/

Re: MySQL and MS SQL Server 2005

concerned 'if it works on MySQL it will work on MS SQL > Server 2005'? > > The SQL strings I use are the really simple ones eg. > INSERT INTO..., > UPDATE FROM...,SET...WHERE... > SELECT FROM...WHERE...ORDER BY... > > Thanks in advance. > > Jonathan Trahair > > > > -- > Sincerely yours, > Olexandr Melnyk <>< > http://omelnyk.net/ -- Sincerely yours, Olexandr Melnyk <>< http://omelnyk.net/

Re: MySQL and MS SQL Server 2005

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

Fwd: auto increment format

eral mailing list archive at Nabble.com. > > > -- > MySQL 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: consitent backup of MyISAM and Innodb tables

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

Re: giving a row the new highest id

se storage engine you're using supports it) -- MySQL 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: 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

Re: giving a row the new highest id

ne can help. thanks! -- MySQL 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.

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 table

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

Re: Object-Oriented database

esn't 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 a

Database with a lot of views

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

Re: Group By / Order BY

For list archives: http://lists.mysql.com/mysql 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

Re: SELECT from 3 tables - Need help

y from 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/