Re: [Linux-programlama] MySQL - LAST_INSERT_ID Nasıl ?

---------

New Message Reply About this list Date view Thread view Subject view Author view Attachment view

From: H. Kerem Cevahir (hkerem@gmail.com)
Date: Mon 08 Aug 2005 - 20:11:46 EEST


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Merhabalar;

"last_insert_id()" fonksiyonunu ayni programlama dinlerinde oldugu
sekilde; bildigimiz bir deger gibi, kullanmaniz gerekmekte.

mysql> insert into deneme (isim) values ('kerem cevahir');
Query OK, 1 row affected (0.00 sec)

mysql> insert into deneme (isim) values ('h. kerem cevahir');
Query OK, 1 row affected (0.00 sec)

mysql> select * from deneme where id=last_insert_id();
+----+------------------+
| id | isim |
+----+------------------+
| 2 | h. kerem cevahir |
+----+------------------+
1 row in set (0.00 sec)

Iyi calismalar...

Ahmet ERDOGAN wrote:
> Merhabalar
>
> Aşağıdaki sorgumda son satırda hata veriyor aceba fonksiyonumu
> yanlış kullanıyorum ?
>
> USE test; INSERT INTO deneme (ad) VALUES ("Ahmet"); SELECT
> LAST_INSERT_ID();
>
> Kolay Gelsin...
>
> ----------------------------------------------------------------------
>
>
> _______________________________________________ Linux-programlama
> mailing list Linux-programlama@liste.linux.org.tr
> http://liste.linux.org.tr/mailman/listinfo/linux-programlama

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFC95JSZltqs+RRVkQRAq9yAJwP0MEVCqJyaBsCnGjt5irpn/us/gCfVlg+
UY0u3alEEKGGgF7LPUt70BE=
=rLo5
-----END PGP SIGNATURE-----

_______________________________________________
Linux-programlama mailing list
Linux-programlama@liste.linux.org.tr
http://liste.linux.org.tr/mailman/listinfo/linux-programlama


New Message Reply About this list Date view Thread view Subject view Author view Attachment view

---------

Bu arsiv hypermail 2.1.2 tarafindan uretilmistir.