Re: Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Anand Kumar
On Mon, Dec 20, 2010 at 9:00 AM, Anand wrote: > Hi guys, > > i am facing a serious issue with my replication , i tried so many things > but no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in master to process some csv files and

Re: Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Lee Gary
Hi Anand, Just try 'load data local infile',it maybe work. Eric 2010/12/20 Anand : > Hi guys, > > i am facing a serious issue with my replication , i tried so many things but > no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in

Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Anand
Hi guys, i am facing a serious issue with my replication , i tried so many things but no luck. my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. we run LOAD DATA INFILE in master to process some csv files and load it into a table, it runs perfectly well in master but wh

Re: Records not being displayed

2010-12-19 Thread Gary
7;] . ''; > echo '' . $row['singles'] . ''; > echo '' . $row['six'] . ''; > echo '' . $row['can'] . ''; > echo '' . $row['bottles'] . ''; > echo ''

Re: Records not being displayed

2010-12-19 Thread Johnny Withers
; echo '' . $row['bottles'] . ''; echo '' . $row['tap'] . ''; echo '' . $row['size'] . ''; echo '' . $row['descrip'] . ''; ''; } echo ''; } All but the

Records not being displayed

2010-12-19 Thread Gary
'tap'] . ''; echo '' . $row['size'] . ''; echo '' . $row['descrip'] . ''; ''; } echo ''; } All but the first row in alphabetical order are displayed properly. Can anyone tell me where I am going wrong? -- Gary __ Information from ESET Smart Security, version of virus signature database 5715 (20101219) __ The message was checked by ESET Smart Security. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Query Stored Index instead of Group By

2010-12-19 Thread Johan De Meersman
On Sun, Dec 19, 2010 at 3:19 AM, Feris Thia < milis.datab...@phi-integration.com> wrote: > Hi Everyone, > > Is there a way to query values stored in our index instead of using "group > by" selection which will produce same results ? > You can't query the index directly, but if you select only fie