Re: How to overwrite existing file with SELECT .. INTO?

Hello Mike, AFAIK, What you have specified is applicable only for tables! But for file in "Select ..into outfile", sure Exit handler is declared when we try to overwrite an existing file! Thanks DEVI.G - Original Message - From: "mos" <[EMAIL PROTECTED]> To: Sent: Sunday, April 15,

state=sending data for too long

Hello, For the following query: select unix_timestamp(beginTime) as bTime,myTable.* from myTable Where nodeID=2 AND flavor In('sim','ofl') AND (deactive= 0 OR deactive>=1176682388) AND unix_timestamp(entryTime)<=1176682388 AND beginTime<=from_unixtime(1546300816) AND elementID In (491507,49150

Re: Is an index on varchar column efficient?

At 06:23 PM 4/15/2007, you wrote: Hi, I have a table with 2 million records but without an index or a primary key. The column upon which I want to create an index is a varchar. Will it give me any advantage when I have to do a select on the column? BTW, here is the scenario: create ta

Re: Is an index on varchar column efficient?

murthy gandikota wrote: Hi, I have a table with 2 million records but without an index or a primary key. The column upon which I want to create an index is a varchar. Will it give me any advantage when I have to do a select on the column? BTW, here is the scenario: create table

Re: can't import

Now, would someone please explain *why* this worked and all my other attempts didn't? Was it because of file permissions? or the linux user id? or that I put a passwork on the mysql root account? or that I changed the ownership of the data file? or that I took out some spaces on the data fil

Is an index on varchar column efficient?

Hi, I have a table with 2 million records but without an index or a primary key. The column upon which I want to create an index is a varchar. Will it give me any advantage when I have to do a select on the column? BTW, here is the scenario: create table `test` (`phonenumber` va