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 Ch. Prajapati
On Sat, Nov 28, 2009 at 3:50 AM, mos
monica friends
news.aol.com/nation/lottery/online_lotery
At 07:40 AM 11/27/2009, Krishna Chandra Prajapati wrote:
Hi Experts,
load data local infile and insert into are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
No. Load Data is the fastest meth
On Fri, 27 Nov 2009 15:34:56 + Miguel Vaz said:
> Hi,
>
> This is my first post, and could use some points of view on the subject.
> Have a project that will have several languages for its records, for places,
> for example, whose names and descriptions will be in 3 languages.
>
> Have alrea
On Nov 27, 2009, at 6:17 PM, Miguel Vaz wrote:
> My 3rd option seems to be the most simple, although i admit it doesnt sound
> quite right. Having fixed table fields for languages doesnt seem correct.
Well, it all depends. If you need to add a column later, you need to do an
ALTER TABLE. In a p
My 3rd option seems to be the most simple, although i admit it doesnt sound
quite right. Having fixed table fields for languages doesnt seem correct.
I can see disavantages in all 3 options, thats why i wanted to ask
everybody's opinion on something like this, i mean, a assume that dealing
with a
I am really interested in the same answer...
I am making a script.. and as I will only have 2 languages I decided to use
you 3rd option (Fields for each language), because of less rows.
But I really would like to know if there is a better approach to this.
*eg. php function:*
function getRecipe
On Nov 27, 2009, at 4:34 PM, Miguel Vaz wrote:
> This is my first post, and could use some points of view on the subject.
> Have a project that will have several languages for its records, for places,
> for example, whose names and descriptions will be in 3 languages.
>
> Have already read several
Hi,
This is my first post, and could use some points of view on the subject.
Have a project that will have several languages for its records, for places,
for example, whose names and descriptions will be in 3 languages.
Have already read several sites about it but always end up with several
persp
Hi Guy`s!
Today i hacked MySql but hove some trouble.
i have two tables (lentas and categories_documents) i try join them:
SELECT `lentas`.* FROM `lentas`
left join categories_documents As cd
ON(cd.document_id = lentas.document_id AND cd.document_type =
lentas.document_type)
WHERE (cd.category_i
Hi Experts,
load data local infile and insert into are the two methods of
inserting data into a mysql table.
Out of the above two method. Is there any faster method of inserting data
into mysql tables.
Thanks,
Krishna Ch. Prajapati
Hello,
When I have a table with (for example) three keys (one primary, auto-
increment, and two uniques on a column, eg. 'code' and 'name'), how
can I (efficiently) know which uniqueness constraint was violated when
doing an insert?
You get an error "#1062 - Duplicate entry 'Value' for key
12 matches
Mail list logo
