upload

hentai link

http://www.indoforum.org/t29155-2/
http://www.unlimitedhentai.com/hentai/home
http://hentaischool.com/
http://bluhentai.com/index2.php
http://doujinland.com/
http://www.aerisdies.com/
http://www.doujin-moe.com/wp/
http://www.english-hentai.blogspot.com/?zx=36d9a570261c0fa7

Bagaimana Cara Membuat Apple Candy Sugar-Free?

Candy apel adalah apel utuh dilapisi dengan gula mengeras dan disajikan dengan tongkat di tengah untuk kemudahan konsumsi. Mereka telah memperlakukan populer untuk anak-anak dan orang dewasa sama selama bertahun-tahun sekarang terutama selama musim gugur di mana apel setiap tahun dipanen. Kebetulan, musim panen bertepatan dengan Halloween di Amerika Serikat dan Guy Fawkes Malam atau Bonfire Night di Inggris.


Sayangnya, karena kadar gula tinggi, apel makan permen mungkin tidak cocok untuk keluarga dan teman-teman yang perlu mengurangi asupan gula mereka. Tapi tunggu, seperti semua makanan dan minuman populer, ada gula-alternatif yang kurang atau gula-gratis! Khawatir bukan sebagai resep ini sangat mudah hanya membutuhkan jumlah waktu minimum dan karya besar dengan apel renyah. Tip ramah meskipun:
* Siapkan sepotong kertas lilin atau aluminium foil. Berbaring ini di atas sebuah nampan yang bersih dan merata lemak ini menggunakan cooking spray non-stick. Tetapkan samping ini.
* Cuci dan kering 6-8 buah apel merah. Hati-hati keluarkan batang dan tongkat tusuk. Walaupun es loli tongkat secara tradisional digunakan, sumpit adalah alternatif praktis sebagai tusuk sate. Pastikan saja dapat membawa tongkat berat dari apel. Setelah semua tusuk sate berada, menyetelnya apel samping.
* Untuk setengah cangkir air, tambahkan 2 cangkir Splenda

How to Make Perfect Candy Apples

Candy apples are a classic treat enjoyed in autumn, especially around Halloween. This guide on how to make perfect candy apples offers tips and advice on preparing delicious candy apples.
The candy apple is prepared by dipping fresh apples into a candy coating, and allowing for it to dry, creating a hard candy shell. The coating can be dyed using food coloring to match any theme, and a number of toppings can be added to the candy apple to suit any taste. While the recipe is simple to follow, candy apples should be prepared with caution and with the supervision of an adult, as the candy coating becomes hot as it cooks.
Preparing candy apples can be a fun project for cooks of all ages and skill level. Read on to learn how to make perfect candy apples.

Step 1: Gather Your Equipment

1. Wooden skewers or popsicle sticks
   • Buy them at your local grocery or party supply store.
   • You can also buy bamboo skewers and cut them in half.
2. Candy thermometer
   • A candy thermometer is very important, especially if you're making candy apples for the first time. You'll need it to make sure your heated sugar reaches the right stage of completion. Judging otherwise can easily lead you to burnt or underdone coatings. However, the thermometer is not necessary if you are just melting chocolate.
   • Make sure your thermometer's accurate. Being off by just a few degrees can mean the difference between delicious and burnt. To check its accuracy, clip on your candy thermometer and set a pot of water to boil. The thermometer should read 212 degrees Fahrenheit or 100 degrees Celsius when the water is boiling. If not, note what temperature it reads at and adjust for the difference.
3. Pot for making the candy coating
4. Second container, bigger than your cooking pot
   • If you heat your coating to a high enough temperature, you'll fill this container with cold water to submerge and cool the pot with your candy apple coating.
5. Tray or baking sheet (for completed apples)
   • Aluminum foil: you'll need this if you do not want to put your finished apples directly on an oiled baking sheet, tray, or serving platter.
   • Alternatively, you can top your baking sheet with a silpat mat.
6. Measuring cups and spoons
7. Wooden spoon
8. Pastry brush, to keep sugar from crystallizing as you work
9. Extra bowls for additional toppings

Step 2: Choosing Your Apples

Making a candy apple is about pairing the sweetness of candy with the right apple. It's exquisite to pair a tart apple with a sweet candy exterior. Of course, if you can't stand tart apples, then pick a sweeter one. However, you want to eschew varieties like Red Delicious, which lacks the firmness required for candy apples, and Rome Beauty, which is primarily used in baking. Recommended apples include:

• • Braeburn: Golden-green to red skin, firm, sweetly tart
  • Fuji: Yellow-green skin, firm, sweet
  • Golden Delicious: golden skin, firm, sweet
  • Granny Smith: green skin, very firm, tart
  • Jonathan: Yellow-red skin, firm, sweetly tart
  • Jonagold: A hybrid of Jonathan and Golden Delicious, firm skin, tangily sweet
  • Lady: Red to yellow skin, firm, sweetly tart
  • McIntosh: Reddish-green skin, firm, sweetly tart

1. Choose smaller apples - they'll be easier to make, easier to eat, and will give you a better candy to apple ratio!
2. Store-bought apples are usually coated with wax, which makes it more difficult to coat them. If possible, buy apples at a farmer's market. Or you can go apple picking and get your own fresh off the tree!
3. If you have no choice but to use wax-coated apples, quickly dip them in boiling water and then wipe away the wax coating.1
4. Chill the apples in the refrigerator until you're ready to start making candy apples.

Step 3: Prepare Your Kitchen

• Get everything gathered before you put the sugar on the stove. You don't want to rush off for your pastry brush and come back to find a pot full of crystallized sugar.

1. Put your pastry brush in a cup of warm water.
2. Butter your baking sheet or tray (or aluminum foil) so it's ready to hold coated apples.
3. Fill the second, larger, container with ice water, if you plan to cook your candy to 310 degrees Fahrenheit.
4. If you want extra toppings on your apples, place the toppings in separate bowls. Possible toppings include:
   • Candy corn
   • Toasted coconut flakes
   • Red hots candies
   • Licorice
   • Chocolate chips
   • Life Savers candies
   • Nuts
   • Sprinkles
   • Jelly beans
   • Gummi bears
   • Dried fruit

Step 4: Get Your Apples Ready

1. Check the apples for firmness and bruising before using.
2. Remove the stems from good apples.
3. Wash and dry your apples.
4. Insert the wooden skewers or popsicle sticks.

Step 5: Make the Candy Coating

Ingredients:

• 1/2 cup corn syrup. Use light corn syrup if you want to color your coating.
• 2 cups sugar. If you use brown sugar your candy coating will take on its darker color. The molasses in the sugar may also make your mixture more susceptible to burning.
• 3/4 cups water
• 3/4 tsp food coloring (optional)23 4

Directions:

1. Place the ingredients listed above (and any variation you choose to add) in a saucepan.
2. Cook over medium-high heat.
3. Stir to dissolve the sugar.
   • You want the sugar to dissolve before the mixture boils; this will help prevent crystallization.
4. Bring the mixture to a boil.
   • Reduce the heat to a medium-low flame if you are using brown sugar. This will take longer, but if you have the heat on a higher flame you risk burning the sugar.
5. Don't stir the sugar mixture once it begins to boil], to avoid crystallizing the candy. Instead, use your pastry brush to brush the pot's sides with warm water, to prevent crystals from forming.5
6. Simmer until the candy reaches 290 degrees Fahrenheit.
7. Remove the candy from heat when it's at 290 degrees Fahrenheit.
   • Sugar is at the soft-crack stage at this temperature.6 For a lighter, more brittle candy shell, heat the sugar more. Remove it from heat when it's between 300 and 310 degrees Fahrenheit.
   • If you heat the sugar to 310 degrees Fahrenheit, place the pot in a cold water bath when you remove it from the stove, to stop the sugar from cooking.2 3 4

Step 6: Coat Your Apples

• When the candy mixture is ready, work quickly to coat the apples, before it hardens.

1. Dip your apples, holding the wooden stick, and submerge completely in the candy.
   • Tilt the pot as necessary and spoon candy over the apples for full coating.
2. If using additional toppings, dip the apples in them before the candy shell hardens.
3. Place apples on the waiting tray or sheet.
4. When all your apples are covered, place them in the refrigerator to cool.

• Once your apples have cooled, you can eat and enjoy! Make sure to eat them within three days of making them.

• If you're giving the apples as gifts, you can place them in plastic or cellophane bags (once they've cooled) and tie off with ribbons.

Popular Variations

• You're not limited to following a recipe. If there's a flavor you'd like to add, try it. For example:

1. Add a cinnamon stick or cinnamon extract to your candy coating for cinnamon-flavored apples.
2. Spice it up by sprinkling nutmeg or allspice into your candy coating.
3. Make more adult apples by adding your favorite liquor or liqueur. 

sumber : http://www.mahalo.com/how-to-make-perfect-candy-apples/

looked nice web site....

get naked for petavi.sualize.us
iphotoscrap

laporan basisdata 4

LAPORAN PRAKTIKUM BASIS DATA

PERTEMUAN KE 4

                                                                                                        

Nama         : Rizky Yuniawan

Nim   : 095610114

SEKOLAH TINGGI MANAJEMEN INFORMATIKA DAN KOMPUTER

AKAKOM

YOGYAKARTA

2011

PERTEMUAN IV

TRANSAKSI

1.                  Pembahasan

Pada pelaksanaan praktikum basis data transaksi, kita harus manjalankan perintah innodb untuk mendukung transaksi, dan jika ingin memeriksa dukungan transaksi gunakan perintah ini.

mysql> show variables like 'have_innodb';

Dan jika saat diperiksa hasilnya seperti diatas, berarti dukungan telah aktif . Sebelum melakukan transaksi kita buat tabelnya dahulu

mysql> use akademik;

Database changed

mysql> create table coba_transaks(pelatihan varchar(10) NOT NULL, instruktur char(15) NOT NULL, primary key(pelatihan)) ENGINE=InnoDB;

Query OK, 0 rows affected (0.16 sec)

Untuk memulai transaksi kita gunakan perintah :

mysql> start transaction;

Query OK, 0 rows affected (0.06 sec)

Dan coba kita masukan data ke tabel transaks

mysql> insert into coba_transaks values('MySQL','Totok'),('Oracle','Enny');

Query OK, 2 rows affected (0.34 sec)

Records: 2  Duplicates: 0  Warnings: 0

Melihat penambahan data menggunakan perintah :

mysql> select*from coba_transaks;

mysql> exit         àuntuk perintah keluar

prtk-2 + login ulang

mysql> use akademik;

Database changed

mysql> select*from coba_transaks;

Empty set

Hasilnya : tabel transaks tidak keluar karena saat akan keluar dari MySQL belum menjalankan perintah COMMIT. Perintah COMMIT digunakan untuk menyimpan data yang telah di ketik sebelumnya 0.00 sec

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

Memasukan data kedalam tabel coba_transaks :

mysql> insert into coba_transaks values('MySQL','Totok'),('Oracle','Enny');

Query OK, 2 rows affected (0.00 sec)

Records: 2  Duplicates: 0  Warnings: 0

mysql> select*from coba_transaks;

mysql> commit;

Query OK, 0 rows affected (0.09 sec)

mysql> exit

prtk-3 + login ulang

mysql> use akademik;

Database changed

mysql> select*from coba_transaks;

Selanjutnya kita akan menjalankan perintah autocommit bernilai 0, yang berarti saat kita meninsert data, data tidak tersimpan secara permanen atau hanya sementara dan saat kita exit data akan hilang.

mysql> select @@autocommit;

mysql> set @@autocommit=0;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into coba_transaks values('sybase','Hartono');

Query OK, 1 row affected (0.00 sec)

mysql> select*from coba_transaks;

mysql> exit

prtk-4 + login ulang

mysql> use akademik;

Database changed

mysql> select*from coba_transaks;

mysql> select @@autocommit;

mysql> set @@autocommit=1;

Query OK, 0 rows affected (0.00 sec)

Hasil autocommit bernilai 0

mysql> insert into coba_transaks values('sybase','Hartono');

Query OK, 1 row affected (0.06 sec)

mysql> select*from coba_transaks;

mysql> exit

prtk-5 + login ulang

Hal diatas terjadi karena nilai autocommit masih berupa 1atau juga dapat dibilang jika mode transaksi masih OFF atau mati.

mysql> use akademik;

Database changed

mysql> select*from coba_transaks;

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

mysql> select*from coba_transaks;

mysql> insert into coba_transaks values ('sybase','Emmy');

ERROR 1062 (23000): Duplicate entry 'sybase' for key 'PRIMARY'

Karena ada kemiripan pada PRIMARY KEY-nya, maka value (‘sybase’,’Emmy’) tidak dapat diinputkan kedalam database. Hal ini terjadi karena mode transaksi autocommit masih bernilai = 1, atau masih dalam keadaaan mati. Karena itulah auto commit harus diaktivkan dengan mengubah nilainya menjadi = 0.

mysql> select @@autocommit;

mysql> set @@autocommit=0;

Query OK, 0 rows affected (0.02 sec)

Re-login

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

mysql> select*from coba_transak;

mysql> insert into coba_transak values('sybase','Emmy');

Query OK, 1 row affected (0.08 sec)

mysql> select*from coba_transak;

mysql> insert into coba_transak values('sybase','Harry');

ERROR 1062 (23000): Duplicate entry 'sybase' for key 'PRIMARY'

Karena ada kemiripan pada PRIMARY KEY-nya, maka value (‘sybase’,’Harry’) tidak dapat diinputkan kedalam database.

mysql> rollback;

Query OK, 0 rows affected (0.08 sec)

Saat rollback diaktivkan, maka semua penambahan data akan dinyatakan tidak valid atau dibatalkan tergantung pada kondisi transaksinya. Perintah dibawah digunakan untuk mengecek jika perintah rollback berhasil dilaksanakan.

mysql> select*from coba_transaks;

2.      Latihan

Membuat tabel basisdata transak_jual dengan atribut kdbrg, nmbrg, jnsbrg, & harga.

mysql> create table transak_jual(kdbrg char(9)not null, nmbrg varchar(30), jnsbrg varchar(10), harga char(15), primary key(kdbrg))engine=InnoDB;

Query OK, 0 rows affected (0.38 sec)

mysql> insert into transak_jual values('a123456','kopi bubuk','minuman','1500'), ('b123456','roti sobek','makanan','5000'), ('e123456','sabun mandi','perlengkapan','1500'), ('a223456','susu kental manis sc','minuman','750'), ('b334567','kecap manis cap sendok 250ml','makanan','2500');

Query OK, 3 rows affected, 1 warning (0.20 sec)

Records: 5  Duplicates: 0  Warnings: 1

Menggunakan perintah :

è Commit

 mysql> create table transak_jual(kdbrg char(9)not null, nmbrg varchar(30), jnsbrg varchar(10), harga char(15), primary key(kdbrg))engine=InnoDB;

Query OK, 0 rows affected (0.38 sec)

 mysql> insert into transak_jual values('a123456','kopi bubuk','minuman','1500'), ('b123456','roti sobek','makanan','5000'), ('e123456','sabun mandi','perlengkapan','1500'), ('a223456','susu kental manis sc','minuman','750'), ('b334567','kecap manis cap sendok 250ml','makanan','2500');

               Query OK, 3 rows affected, 1 warning (0.20 sec)

               Records: 5  Duplicates: 0  Warnings: 1

mysql> select*from transak_jual;

mysql> commit;

Query OK, 0 rows affected (0.08 sec)

mysql> exit

setelah login ulang :

è Autocommit

mysql> use akademik;

Database changed

mysql> select*from transak_jual;

mysql> select @@autocommit;

mysql> set @@autocommit=0;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into transak_jual values('c123456','elpiji 3kg','bahan bakar','30000');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select*from transak_jual;

mysql> exit

setelah login ulang :

Jika autocommit = 1, maka :

mysql> select @@autocommit;

mysql> set @autocommit=1;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into transak_jual values('c23456','minyak tanah','bahan bakar','8000');

Query OK, 1 row affected, 1 warning (0.08 sec)

mysql> select*from transak_jual;

mysql> exit

setelah login ulang :

è Rollback àimplisit

                àeksplisit

 mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into transak_jual values('a898999','air mineral','minuman','2000');

Query OK, 1 row affected (0.00 sec)

mysql> select*from transak_jual;

mysql> rollback;

Query OK, 0 rows affected (0.06 sec)

mysql> select*from transak_jual;

3.      Tugas

1.            Database bank

mysql> use bank;

Database changed

2.                     Table nasabah, saldo, & transaksi

mysql> create table nasabah(norek char(30) not null, nama char(30), alamat varchar(50),noid char(20), cabang varchar(20))engine=InnoDB;

Query OK, 0 rows affected (0.13 sec)

mysql> create table saldo(tgl char(6), sandi char(2), debet char(20), kredit char(20), pc char(2)not null , saldo char(30), ket varchar(9), primary key(pc) );

Query OK, 0 rows affected (0.11 sec)

mysql> create table transaksi(tgl char(6)not null, debet char(20),kredit char(20), saldo char(30)not null, primary key(saldo));

Query OK, 0 rows affected (0.39 sec)

3.                     Isi data table

mysql> insert into nasabah values('1001010123456121','Rizky Yuniawan','Jl Janti', '900010210001231009', 'Yogja');

Query OK, 1 row affected (0.08 sec)

mysql> insert into nasabah values('1001010123456789','Noormalisa','Jl Buntu', '900110330001231009', 'Solo');

Query OK, 1 row affected (0.34 sec)

mysql> insert into nasabah values('1001010123456666','Rifta Nor Hastuti','Jl Pelita timur', '900110330001234567', 'Bandung');

Query OK, 1 row affected (0.33 sec)

mysql> select*from nasabah;

+------------------+-------------------+-----------------+--------------------+---------+

| norek            | nama              | alamat          | noid               |cabang  |

+------------------+-------------------+-----------------+--------------------+---------+

| 1001010123456121 | Rizky Yuniawan    | Jl Janti        | 900010210001231009 |Yogja   |

| 1001010123456789 | Noormalisa        | Jl Buntu        | 900110330001231009 |Solo    |

| 1001010123456666 | Rifta Nor Hastuti | Jl Pelita Timur | 900110330001234567 |Bandung |

+------------------+-------------------+-----------------+--------------------+---------+

3 rows in set (0.00 sec)

mysql> insert into saldo values('241011','1','1,000,000.00','-','11','5,987,321.00','WDO70001121');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into saldo values('261011','1','-','1,000,000.00','12','6,987,321.00','TDO70001121');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into saldo values('131111','2','-','7,000,000.00','13','13,987,321.00','WDO70002121');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select*from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket|

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011|

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011|

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021|

+--------+-------+--------------+--------------+----+---------------+-----------+

3 rows in set (0.00 sec)

mysql> insert into transaksi values('241011','1,000,000.00','-','5,987,321.00');

Query OK, 1 row affected (0.00 sec)

mysql> insert into transaksi values('261011','-','1,000,000.00','6,987,321.00');

Query OK, 1 row affected (0.01 sec)

mysql> insert into transaksi values('131111','-','7,000,000.00','13,987,321.00')

;

Query OK, 1 row affected (0.00 sec)

mysql> select*from transaksi;

+--------+--------------+--------------+---------------+

| tgl    | debet        | kredit       | saldo         |

+--------+--------------+--------------+---------------+

| 241011 | 1,000,000.00 | -            | 5,987,321.00  |

| 261011 | -            | 1,000,000.00 | 6,987,321.00  |

| 131111 | -            | 7,000,000.00 | 13,987,321.00 |

+--------+--------------+--------------+---------------+

3 rows in set (0.00 sec)

4.                     Commit

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into saldo values('231111','2','-','2,150,000.00','14','16,137,321

.00','WDO70012121');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> commit;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

mysql> select * from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket       |

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011 |

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011 |

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021 |

| 231111 | 2     | -            | 2,150,000.00 | 14 | 16,137,321.00 | WDO700121 |

+--------+-------+--------------+--------------+----+---------------+-----------+

4 rows in set (0.00 sec)

Autocommit

mysql> select @@autocommit;

+--------------+

| @@autocommit |

+--------------+

|            1 |

+--------------+

1 row in set (0.00 sec)

mysql> set @autocommit=0;

Query OK, 0 rows affected (0.00 sec)

mysql> insert into saldo values('011211','3','4,000,000.00','-','15','12,137,321.00','ODO800111');

Query OK, 1 row affected (0.00 sec)

mysql> select * from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket       |

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011 |

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011 |

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021 |

| 231111 | 2     | -            | 2,150,000.00 | 14 | 16,137,321.00 | WDO700121 |

| 011211 | 3     | 4,000,000.00 | -            | 15 | 12,137,321.00 | ODO800111 |

+--------+-------+--------------+--------------+----+---------------+-----------+

5 rows in set (0.00 sec)

mysql>exit

setelah login ulang

mysql> use bank;

Database changed

mysql> select* from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket       |

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011 |

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011 |

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021 |

| 231111 | 2     | -            | 2,150,000.00 | 14 | 16,137,321.00 | WDO700121 |

+--------+-------+--------------+--------------+----+---------------+-----------+

5 rows in set (0.00 sec)

5.                     Rollback

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

mysql> select* from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket       |

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011 |

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011 |

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021 |

| 231111 | 2     | -            | 2,150,000.00 | 14 | 16,137,321.00 | WDO700121 |

+--------+-------+--------------+--------------+----+---------------+-----------+

4 rows in set (0.00 sec)

mysql> insert into saldo values('011211','3','-','500,000.00','16','16,637,321.00','GDO800001');

Query OK, 1 row affected (0.00 sec)

mysql> insert into saldo values('011211','3','-','1,500,000.00','16','17,637,321.00','GDO800001');

ERROR 1062 (23000): Duplicate entry '16' for key 'PRIMARY'

Gagal memasukan data karena adanya duplikasi pada PRIMARY KEYnya

mysql> select* from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket       |

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011 |

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011 |

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021 |

| 231111 | 2     | -            | 2,150,000.00 | 14 | 16,137,321.00 | WDO700121 |

| 011211 | 3     | -            | 500,000.00   | 16 | 16,637,321.00 | GDO800001 |

+--------+-------+--------------+--------------+----+---------------+-----------+

5 rows in set (0.00 sec)

mysql> rollback;

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select* from saldo;

+--------+-------+--------------+--------------+----+---------------+-----------+

| tgl    | sandi | debet        | kredit       | pc | saldo         | ket       |

+--------+-------+--------------+--------------+----+---------------+-----------+

| 241011 | 1     | 1,000,000.00 | -            | 11 | 5,987,321.00  | WDO700011 |

| 261011 | 1     | -            | 1,000,000.00 | 12 | 6,987,321.00  | TDO700011 |

| 131111 | 2     | -            | 7,000,000.00 | 13 | 13,987,321.00 | WDO700021 |

| 231111 | 2     | -            | 2,150,000.00 | 14 | 16,137,321.00 | WDO700121 |

+--------+-------+--------------+--------------+----+---------------+-----------+

 5 rows in set (0.00 sec)