on Thursday, December 12, 2002, 10:05:43 AM, Dwi wrote:
> sori mpu. itu last_insert_id() dapetnya dari mana???
> apa itu function??? udf kah???
Taken from MySQL Reference Manual for version 4.0.3-beta versi chm:
LAST_INSERT_ID([expr])
Returns the last automatically generated value that was inserted
into an AUTO_INCREMENT column. See mysql_insert_id().
mysql> SELECT LAST_INSERT_ID();
-> 195
The last ID that was generated is maintained in the server on a
per-connection basis. It will not be changed by another client.
It will not even be changed if you update another AUTO_INCREMENT
column with a non-magic value (that is, a value that is not NULL
and not 0).
If you insert many rows at the same time with an insert statement,
LAST_INSERT_ID() returns the value for the first inserted row.
The reason for this is so that you it makes it possible to easily
reproduce the same INSERT statement against some other server.
... [deleted]
MySQL Reference Manual (C) 2002 MySQL AB
--
Cheers *^_^*
t3d0n9
----------------------------------------------------------------------------
Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp
250.000 tunai
----------------------------------------------------------------------------
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/CBxunD/vN2EAA/xGHJAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
