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
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
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,
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
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
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
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
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
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
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
monica friends
news.aol.com/nation/lottery/online_lotery
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
12 matches
Mail list logo
