2010/12/30 Bucatarul :
> e...@servicii.info.ro wrote:
>>> Multumesc
>>>
>>> mysql_insertid e ok pt scenariul meu.
>>>
>>>
>> Sau, independent de API:
>>
>> INSERT INTO foo (auto,text) VALUES(NULL,'text'); # generate ID by
>> inserting NULL
>> INSERT INTO foo2 (id,text) VALUES(LAST_INSER
On 12/30/2010 5:00 AM, Bucatarul wrote:
> Rant-uri de craciun :
> Ca chestie mysql_insertid() e wrapper peste SELECT LAST_INSERT_ID() ;).
> Si last_insert_id() e gandit cand faci lock la tables inainte, ca daca
> baza de date e accesata multihreded nu se stie ce ai acolo.
Ba se stie daca citesti
e...@servicii.info.ro wrote:
>> Multumesc
>>
>> mysql_insertid e ok pt scenariul meu.
>>
>>
> Sau, independent de API:
>
> INSERT INTO foo (auto,text) VALUES(NULL,'text'); # generate ID by
> inserting NULL
> INSERT INTO foo2 (id,text)VALUES(LAST_INSERT_ID(),'text'); # use ID
> in
On Wed, 2010-12-29 at 08:41 +0200, e...@servicii.info.ro wrote:
> > Multumesc
> >
> > mysql_insertid e ok pt scenariul meu.
> >
> Sau, independent de API:
>
> INSERT INTO foo (auto,text) VALUES(NULL,'text'); # generate ID by
> inserting NULL
> INSERT INTO foo2 (id,text)VALUES(LAST_INS
> Multumesc
>
> mysql_insertid e ok pt scenariul meu.
>
Sau, independent de API:
INSERT INTO foo (auto,text) VALUES(NULL,'text'); # generate ID by
inserting NULL
INSERT INTO foo2 (id,text)VALUES(LAST_INSERT_ID(),'text'); # use ID
in second table
http://dev.mysql.com/doc/refman/5.0/e
Multumesc
mysql_insertid e ok pt scenariul meu.
On Tue, 2010-12-28 at 18:44 +0200, Petru Ratiu wrote:
> 2010/12/28 Mircea MITU :
> > Hello
> >
> > am o mica aplicatie interna ce foloseste 2 tabele mysql, de forma:
> >
> > T1: id (int, autoincrement), nume
> > T2: id, ceva
> >
> > Intr-un anume sc
--- On Tue, 12/28/10, Petru Ratiu wrote:
From: Petru Ratiu
Subject: Re: [rlug] mysql get autoincrement
To: "Romanian Linux Users Group"
Date: Tuesday, December 28, 2010, 6:44 PM
2010/12/28 Mircea MITU :
> Hello
>
> am o mica aplicatie interna ce foloseste 2 tabele mysq
2010/12/28 Mircea MITU :
> Hello
>
> am o mica aplicatie interna ce foloseste 2 tabele mysql, de forma:
>
> T1: id (int, autoincrement), nume
> T2: id, ceva
>
> Intr-un anume scenariu, datele le inserez astfel (kinda pseudocod):
>
> query1: insert into t1 NULL, valoare_nume (T1.id fiind
>
Hello
am o mica aplicatie interna ce foloseste 2 tabele mysql, de forma:
T1: id (int, autoincrement), nume
T2: id, ceva
Intr-un anume scenariu, datele le inserez astfel (kinda pseudocod):
query1: insert into t1 NULL, valoare_nume (T1.id fiind
autoincrement, este generat de mysql