MySQL: Ngambil Data Terakhir

21 November 2006 oleh admin

Beberapa waktu yg lalu ada diskusi di milis PHPUG bagaimana cara ngambil data terakhir dari database, misal aja kita punya data:


   koding    urut  kode    nilai
   ------  ------  ------  ------
   201111  (NULL)  (NULL)  (NULL)
   201112  (NULL)  (NULL)  (NULL)
   201113    1004  035A      1000
   201114    1005  035A      2000
   201114  (NULL)  (NULL)  (NULL)
   201114    1006  029A      1200
	

Hasil yg ingin ditampilkan adalah:


   koding  urut    kode    nilai
   ------  ------  ------  ------
   201111  0000    0000    0000
   201112  0000    0000    0000
   201113  1004    035A    1000
   201114  1005    035A    2000
	

Baca selengkapnya »

Popularity: 2% [?]

MySQL 5.0

25 October 2005 oleh admin

Tadi pagi ngecek e-mail ada berita dari MySQL:

MySQL 5.0 Now Available for Production Use
Enterprise Platform Vendors Express Enthusiastic Support for World’s Most Popular Open Source Database
Major New Version Delivers Advanced SQL Standard-Compliant Features
Such as Stored Procedures, Triggers, Views & New Pluggable Storage Engines

UPPSALA, Sweden & CUPERTINO, Calif. — October 24, 2005 — MySQL AB, developer of the world’s most popular open source database, today announced the general availability of MySQL 5.0, the most significant product upgrade in the company’s ten-year history. Starting today, MySQL 5.0 can be downloaded under the open source GPL license at http:/dev.mysql.com.

“We are quite proud to deliver this new version of MySQL — as it includes the most-requested features from our users, customers and partners,” said Marten Mickos, CEO of MySQL AB. “With their feedback, we have been able to provide important enterprise-class features while staying true to MySQL’s renowned heritage of high-performance! , reliability and ease-of-use.”

… tak potong disini …

donlot ach …
pengin ngerasain juga kayak apa kemampuannya :D

Popularity: 1% [?]

Siyal

14 June 2005 oleh admin

Siyal ……………………………….

Siyal yg pertama, gw gak tau kenapa, semalem Apache + MySQL gw ngadat. Udah gw utak-atik tetep gak mau jalan. Anjrit dah, mana program belum jadi x-(

Siyal yg kedua, td jalur berangkatnya muter-muter. Gak tau kenapa jalannya ditutup. Terpaksa muter-muter kesana kemari nyari jalan tikus x-(

Popularity: 1% [?]

Password Hashing di MySQL 4.1

29 March 2005 oleh admin

Mumpung inget, soale habis install ulang.

Buat temen2 yang nyoba make MySQL versi 4.1.x pasti rada kaget. Bukan karena banyaknya featur yang ditambahkan, tetapi semua aplikasi yang sudah dibuat jadi ngadat. Error kah ? Tapi kok aplikasi2 lain kayak phpMyAdmin, MySQL Front, dll. juga ikutan ngadat ? Malah keluar pesen:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Baca selengkapnya »

Popularity: 5% [?]