[snip]
> Sorry my question... but why I must use JOIN if I can use SELECT * FROM
> table1 AND table2 AND table3 WHERE table1.id=table2.id=table3 not?
> thanks
>
> + _
[/snip]
select table1.field1, table1.field2, table2.field
> Sorry my question... but why I must use JOIN if I can use SELECT * FROM
> table1 AND table2 AND table3 WHERE table1.id=table2.id=table3 not?
> thanks
You can not use that syntax on MySQL (at least not on v5.0 or v5.1, I
do not know about earlier versions).
>// Emiliano Boragina _
>//
gina [mailto:emiliano.borag...@gmail.com]
Enviado el: Sábado, 11 de Julio de 2009 11:08 a.m.
Para: 'php-db@lists.php.net'
Asunto: RE: [PHP-DB] mysql_insert_id() and JOIN
> Hi again
>
> I dont understand how to use this two
>
> I read php.net and other sites, but dont understand
> Hi again.
>
> I dont understand how to use this two.
>
> I read php.net and other sites, but dont understand...
http://dev.mysql.com/doc/
Available in the major languages, pick your filter and start reading.
Having documentation in your own language may help a lot towards
understanding.
> I
> Hi again
>
> I dont understand how to use this two
>
> I read php.net and other sites, but dont understand...
http://dev.mysql.com/doc/
Available in the major languages, pick your filter and start reading.
Having documentation in your own language may help a lot towards
understanding.
> I h
Hi again
I dont understand how to use this two
I read php.net and other sites, but dont understand...
I have this four tables: table1, 2, 3 and 4
So the SELECT is like this?:
This is with FULL JOIN... How identificate the left table if I want to use
LEFT JOIN?
How is the UPDATE?
And t
Any further thoughts?
Rich
> -Original Message-
> From: Randy Phillips [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 9:30 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()
>
>
> on 1/28/03 11:42 AM, Jo
on 1/28/03 11:42 AM, John W. Holmes at [EMAIL PROTECTED] wrote:
>> The reason I ask is, if you use mysql_insert_id() on a busy server and
> it
>> does not function on a per-connection basis, don't you run the risk of
>> getting the last ID of somebody else's INSERT query on the server?
>
> Yes, t
> So I read this thread and the MySQL doc on mysql_insert_id() and still
> have
> a related question.
>
> Does mysql_insert_id() function on a per-connection basis? I read the
> stuff
> on last_insert_id() and it specifically mentions that the last ID is
> stored
> on the server on a per-connectio
ginal Message-
> From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 11:37 AM
> To: Randy Phillips; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()
>
>
> > I've been checking the last_insert_
> I've been checking the last_insert_id() function out and I am curious. The
> MySQL docs say to use the mysql_insert_id() function after an "insert
into"
> query to grab the key value. Both seem to work; however, there are some
> subtle differences.
>
> Which is the best one to use after a single
Hi
I've been checking the last_insert_id() function out and I am curious. The
MySQL docs say to use the mysql_insert_id() function after an "insert into"
query to grab the key value. Both seem to work; however, there are some
subtle differences.
Which is the best one to use after a single insert
Thanks Jason,
That was the answer I was looking for! It works like you suggested!!
Thanks
regards,
bart
-Oorspronkelijk bericht-
Van: Jason Wong [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 28 januari 2002 13:52
Aan: [EMAIL PROTECTED]
Onderwerp: Re: [PHP-DB] mysql_insert_id
On Monday 28 January 2002 20:18, B. Verbeek wrote:
> I already run the query without the value of the primary-key field:
>
> $q_orders_id2 = "INSERT INTO orders(orders_datum, orders_sessid)";
> $q_orders_id2.= " VALUES ('$date', '$sid')";
> $r_orders_id2 = mysql_query($q_orders_id2, $sqllink
sql_query()...
>>How do I define a linkidentifier for a specific call to
mysql_query() and then use mysql_insert_id() with that
linkidentifier of the query?
regards
Bart
-Oorspronkelijk bericht-
Van: Alberto. Sartori [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 28 januari 2002 13:11
Aan:
Hello,
How do I use the linkidentifier to get me the last_inserted_id
(mysql_insert_id) from a auto_increment-colomn?
Do I use:
>>
$q_orders_id2 = "INSERT INTO orders(orders_datum, orders_sessid)";
$q_orders_id2.= " VALUES ('$date', '$sid')";
$r_orders_id2 = mysql_query($q_orders_id2, $sql
on 1/15/02 4:08 PM, Wee Chua at [EMAIL PROTECTED] appended the
following bits to my mbox:
> Is it possible that I would get the wrong ID (Not the ID I just inserted in
> Auto_Increment field) by using mysql_insert_id function if someone is also
> inserting record at the same time? How does mysql_
Hi,
Is it possible that I would get the wrong ID (Not the ID I just inserted in
Auto_Increment field) by using mysql_insert_id function if someone is also
inserting record at the same time? How does mysql_insert_id work accurately?
Thanks,
Wee
--
PHP Database Mailing List (http://www.php.net/)
Is there a known way to "reset" this field? If I make a call and it
succeeds,
then it should be set. If it fails, shouldn't it at least be reset to 0
or -1 instead
of simply the last successful insert? Is this the expected behavior?
-Szii
--
PHP Database Mailing List (http://www.php.net/)
T
19 matches
Mail list logo
