Re: Consult with group

In the last episode (Nov 28), armando said: > i have a question, i'm searching for a while and do not find some > reference how to do that. > > a simple query return this: > > dato1 dato2 dato3 estado1 fecha1 > dato1 dato2 dato3 estado2 fecha2 > dato1 dato2 dato3 estado3 fecha3 > dato4 dato5 dato6

Is LOAD INDEX INTO CACHE replicated?

Are SQL statements like CACHE INDEX or LOAD INDEX INTO CACHE replicated? If so, is there a way to prevent that replication? If a slave mysqld restarts, wouldn't it need to execute CACHE INDEX and LOAD INDEX INTO CACHE statements from its --init-file? And if a master mysql restarts, would the sla

Consult with group

i have a question, i'm searching for a while and do not find some reference how to do that. a simple query return this: dato1 dato2 dato3 estado1 fecha1 dato1 dato2 dato3 estado2 fecha2 dato1 dato2 dato3 estado3 fecha3 dato4 dato5 dato6 estado1 fecha4 dato4 dato5 dato6 estado2 fecha5 dato4 dato5

Re: INSERT DATA INTO TABLE

At 12:09 AM 11/28/2009, Krishna Chandra Prajapati wrote: Hi Mos, In the below two command does 1 is faster than 2. 1. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet; 2. LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet LINES TERMINATED BY '\r\n' enclosed by '"'; Thanks, Krishna