Re: [rlug] mysql get autoincrement

2010-12-30 Fir de Conversatie Petru Ratiu
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

Re: [rlug] mysql get autoincrement

2010-12-30 Fir de Conversatie Laurentiu Matei
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

Re: [rlug] mysql get autoincrement

2010-12-29 Fir de Conversatie 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_INSERT_ID(),'text'); # use ID > in

Re: [rlug] mysql get autoincrement

2010-12-29 Fir de Conversatie Mircea MITU
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

Re: [rlug] mysql get autoincrement

2010-12-28 Fir de Conversatie emil
> 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

Re: [rlug] mysql get autoincrement

2010-12-28 Fir de Conversatie Mircea MITU
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

Re: [rlug] mysql get autoincrement

2010-12-28 Fir de Conversatie Ticlea Petru Alexandru
--- 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

Re: [rlug] mysql get autoincrement

2010-12-28 Fir de Conversatie Petru Ratiu
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 >  

[rlug] mysql get autoincrement

2010-12-28 Fir de Conversatie 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 autoincrement, este generat de mysql