RE: Happy New Year

Have a great and cherishable year ahead *** Happy 2009 wishes from Me & Team ADA *** Rakesh, "aDa" www.adaindia.net www.hybridskills.com www.kalyxindia.com www.indianweatherman.org

Re: slow query log

mysql> explain SELECT SUM(COUNTER_VALUE) FROM STO_LIS sl, -> SCAT_LIS sfl WHERE sl.STO_LIS_ID = -> sfl.LIS_ID AND sfl.CAT_ID = '-1'; ++-+---+--+---+---+-+-+--+-+ | id | select_type | ta

How to Use Cascade Delete Properly

I'm trying to understand how to use cascade delete properly but not sure if I have this backwards or not. Here's an example: I have two tables: mysql> describe adsource; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra |

Re: how to disable InnoDB and MyISAM on ndb cluster

Hi Nipuna, InnoDB can be disabled with the skip-innodb option. MyISAM can't really be disabled because it's required to read the grant tables. -Eric On Sat, Dec 27, 2008 at 4:21 AM, Nipuna Perera wrote: > Hi All, > > I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our server > machi

RE: Can a JOIN statement do this?

Happy New Year Mike- JOIN USING(colId) and or JOIN ON(table1.colId=table2.colIdentifier) will preserve the use of Indexes which is faster LIKE casts off Indexes and does a FTS HTH Martin Any recommendations on non-PHP Forum Software for Apache? __